Description
Please make sure to use SPSS to finish it !
The first file is the instruction and you will need the other three excel worksheet.
1) The data in the excel file labelled “Fav Sport” shows the result of a survey of several Introduction to Statistics students who were asked what is their favorite sport to participate in.
a) (10 pts) Make a pie chart of the data showing percents.
b) (10 pts) Make a bar chart of the data showing counts.
2) The data in the file labeled “Mass Property Crime” shows the Massachusetts property crime rate for the years 1970 to 2012.
a) (10 pts) Make a time series plot of the data.
b) (9 pts) What are your observations based on the time series plot, trends etc.
c) (5 pts) Determine the following: Mean, Median, Standard deviation, Q1 and Q3.
d) (10 pts) Make a box plot of the data.
e) (9 pts) What are your observations from the box plot?
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Please find answer.Thank you.
Use SPSS for all analytic work. Failure to use SPSS where applicable will result in the problem(s) not being graded.
1) The data in the excel file labelled “Fav Sport” shows the result of a survey of several Introduction to Statistics students
who were asked what is their favorite sport to participate in.
a)
(10 pts) Make a pie chart of the data showing percents.
b)
(10 pts) Make a bar chart of the data showing counts.
2) The data in the file labeled “Mass Property Crime” shows the Massachusetts property crime rate for the years
1970 to 2012.
a)
(10 pts) Make a time series plot of ...