QNT561 Education Specialist / qnt561.com QNT561 Education Specialist / qnt561.com | Page 43

Create a Microsoft ® Excel ® spreadsheet with the two variables from a dataset for your choosing. Analyze the data with MegaStat ® , StatCrunch ® , Microsoft ® Excel ® or other statistical tool(s), including: (a) Descriptive stats for each numeric variable and (b) Histogram for each numeric variable and either (c) or (d) (c) Bar chart for each attribute (non numeric) variable (d) Scatter plot if the data contains two numeric variables Determine the appropriate descriptive statistics.(a) For normally distributed data use the mean and standard deviation. (b) For significantly skewed data use the median and interquartile range. Submit the spreadsheet/work and explain your thought process and results. ------------------------------------------------------------------------------------ QNT 561 Week 4 DQ 1 For more course tutorials visit www.qnt561.com does technological advancement affect the ability to collect data? Provide examples. Does this advancement increase the chance for errors? Explain. ------------------------------------------------------------------------------------ QNT 561 Week 4 DQ 2