Create a Microsoft® Excel® spreadsheet with any two variables from a dataset
Create a Microsoft® Excel® spreadsheet with any two variables from a dataset.
Using MegaStat®, StatCrunch®, Microsoft® Excel®or other statistical tool(s), do the following:
(a) Calculate Appropriate Descriptive statistics variable
(b) Create a Histogram continuous variable
(c) Create a pie chart discrete variable
(d) Create a Scatter plot if the data contains two continuous variables
When calculating the appropriate descriptive statistics:
(a) distributed data use the mean and standard deviation.
(b) skewed data use the median and interquartile range.
Use the Individual Methodology Findings Template to complete the descriptive statistics.
Use the Descriptive Statistics and Interpretation Example to develop an interpretation of the descriptive statistics.
Format your paper consistent with APA guidelines.
Submit both the spreadsheet and the completed Individual Methodology Findings Template.
PAIR MALE FEMALE
1 29300 28800
2 41500 41600
3 40400 39800
4 38500 38500
5 43500 42600
6 37800 38000
7 69500 69200
8 41200 40100
9 38400 38200
10 59200 58500
11 years ago
Purchase the answer to view it

- descriptstats.xlsx