Economics
San Diego State University Health Education and Crime Statistical Research PPT

San Diego State University

### Question Description

I’m trying to study for my Economics course and I need some help to understand this question.

Must use websites in the PowerPoint slides

Must use Excel to create data entries and graph then export graph to PowerPoint

### Unformatted Attachment Preview

Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Data: https://www.iihs.org/topics/fatality-statistics/detail/yearly-snapshot
Motor vehicle crash deaths by month in 2018
Month
Deaths
January
2828
February
2511
March
2850
April
2788
May
3206
June
3296
July
3326
August
3254
September
3276
October
3368
November
2965
December
2892

Metrics
Mean
Median
Variance
StDev
Coefficient
Range
90%
Quintiles
-25%
-75%
Skew

Motor vehicle crash deaths by month in 2018
4000
3500
3000
2500
2000
1500
1000
500

0

3046.667
3085.5
75940.79
275.5736
9.045084
857
3355.4
2833.5
3291
-0.50994

Z-test for whether February is statistically significant
Mean
3046.667
February
2511
Z-score
P-value

-6.73
0

Yes, February is statistically significantlly different

Infant Mortality Rates and GDP by State in 2
3000000
2500000
2000000
1500000
1000000
500000
0

AL
AZ
CA
CT
FL
HI
IL
IA
KY
ME
MA
MN
MO

Infant Mortality Rates and GDP by State in 2017
State
Mortality Rate GDP
AL
7.4
213903
AK
5.6
54403
AZ
5.7
10589
AR
8.2
126263
CA
4.2 2802289
CO
4.5
351666
CT
4.5
265876
DE
6.6
74978
FL
6.1
984138
GA
7.2
563784
HI
5.3
89302
ID
4.6
73324
IL
6.1
835642
IN
7.3
364649
IA
5.3
191072
KS
6.1
160390
KY
6.5
205935
LA
7.1
2510...

SoCalTutor428 (1321)
New York University
Review
Review

Anonymous
Solid work, thanks.

Anonymous
The tutor was great. I’m satisfied with the service.

Anonymous
Goes above and beyond expectations !

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4