6 assignments

WS1Homework2.xlsx

Prb1

PULSE	Place Pivot Table here:	DIRECTIONS:
60		Using male PULSE data, create a pivot table of Pulse and count of Pulse with Groupings starting at 40 to 100 width 10.	(8 Points)
74
86		Question:
54		Do the pulse rates of males appear to be normally distributed?
90			(2 points)
80
66		Source: Essentials of Statistics by Mario Triola
68
68		Access this helpful video:	Video
56
80
62
74
60
52
60
66
64
64
46
68
58
68
70
56
66
78
68
62
70
72
74
64
50
70
58
60
88
84
76

PULSE	Place Histogram here:	DIRECTIONS:
60		Using male PULSE data, create a histogram and answer the question.	(8 Points)
74
86		Question:
54		Does the histogram appear to depict data that have a normal distribution? Why or why not?
90			(2 points)
80
66
68		Base the chart from a frequency distrbution.
68
56
80
62
74
60
52
60		Source: Essentials of Statistics by Mario Triola
66		Access this helpful video:	Video
64
64
46
68
58
68
70
56
66
78
68
62
70
72
74
64
50
70
58
60
88
84
76

VOL	IQ	Source: Essentials of Statistics by Mario Triola Insert scatterplot here:	DIRECTIONS:
1173	101		Using Brain VOL as X and IQ as Y create a scatterplot and answer the question. Make the minimum X value on the X axis to be 800 to see the points more clearly.	(8 Points)
1079	96
1067	93		Question:
1104	88		Does the scatterplot support the hypothesis that larger brains have more intelligence?
1347	94			(2 points)
1439	85
1029	97
1100	114
1204	113
1160	124
1005	96
963	89
1035	87		Source: Essentials of Statistics by Mario Triola
1027	87		Access this helpful video:	Video
1281	101
1272	103
1051	103
1079	96
1034	127
1070	126

Year	Home Runs	Source: Essentials of Statistics by Mario Triola Insert time-series here:	DIRECTIONS:
1990	3317		Using Home run data since 1990 create a time-series graph and answer the question.	(8 Points)
1991	3385
1992	3038		Question:
1993	4030		Is there a trend?
1994	3306			(2 points)
1995	4081
1996	4962
1997	4640
1998	5064
1999	5528
2000	5693		Source: Essentials of Statistics by Mario Triola
2001	5458
2002	5059		Access this helpful video:	Video
2003	5207
2004	5451
2005	5017
2006	5386
2007	4957
2008	4878
2009	4655

Survey on Frustrating Sounds Heard in a Day		Source: Essentials of Statistics by Mario Triola Insert Pareto chart here:	DIRECTIONS:
Jackhammers	279		Using the survey data in Columns A, B, create a Pareto chart. Make sure to put a title on the chart.	(10 Points)
Car alarms	388
Barking dogs	128
Crying babies	209
			Source: Essentials of Statistics by Mario Triola
			Access this helpful video:	Video

Weekly Instruction time for children		Source: Essentials of Statistics by Mario Triola Insert pie chart here:	DIRECTIONS:
Japan	23.8		Using the survey data in Columns A, B, create a Pie chart. Make sure to put a title on the chart. Also, answer the question.	(8 Points)
China	26.9
U.S.	22.2		Question: Does it make sense to use a pie chart for the given data?
U.K.	24.6
France	24.8			(2 points)
			Source: Essentials of Statistics by Mario Triola
			Access this helpful video:	Video