Using the Excel Spreadsheet attached, run the following descriptive statistics: Mean Median Standard Deviation (population) pay careful attention to what you put in here - if you put in STDEV.P, that is population. If you put in S...
Using the Excel Spreadsheet attached, run the following descriptive statistics:
Mean
Median
Standard Deviation (population) pay careful attention to what you put in here - if you put in STDEV.P, that is population. If you put in STDEV.S, that is sample. Same with VAR.P and VAR.S for variance below.
Variance (population)
Confidence interval - Report the Confidence interval at .05 significance level/95% confidence level. Remember to report the range (Mean +/- the confidence interval)
Descriptive Statistics using Data Analysis
Compare your calculations to the Descriptive Statistics - Are they the same?
Would you use the Mean or the Median for this data set? Why?
Design a research scenario for this data set - this is completely open to your endless possibilities. Give a null and alternative hypothesis. What would be some possible operational definitions? Who might be your sample for this?
Submit your Excel Spread sheet and your summary.
For privacy and security, delivered files are not available for public download. The student who placed this order can sign in to access the delivered work from their dashboard.
Post your assignment and receive offers from verified writers in your subject area.
Post a new assignment Back to latest orders