An insurance company is looking over accident statistics. They want to model the population of all drivers for the population parameter of the standard deviation and variance of the age of the driver involved in an automobile accident. They have a sample of 100 accidents from around the country. The age of the driver in each of these accidents is provided below. Use Excel to calculate the sample standard deviation and the sample variance. Round your answers to one decimal place. Do not round until you've calculated your final answer "Age of people in accident"48643346436728189044472440202747683248472248217347302918487364454920205066654187873417203176493089672222455023481746382942254720463119214227226621236675744621461969202048238851284918204522313823284939   Standard deviation:  Variance:

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 19PFA
icon
Related questions
icon
Concept explainers
Topic Video
Question

An insurance company is looking over accident statistics. They want to model the population of all drivers for the population parameter of the standard deviation and variance of the age of the driver involved in an automobile accident. They have a sample of 100 accidents from around the country. The age of the driver in each of these accidents is provided below.

Use Excel to calculate the sample standard deviation and the sample variance.

Round your answers to one decimal place. Do not round until you've calculated your final answer

"Age of people in accident"
48
64
33
46
43
67
28
18
90
44
47
24
40
20
27
47
68
32
48
47
22
48
21
73
47
30
29
18
48
73
64
45
49
20
20
50
66
65
41
87
87
34
17
20
31
76
49
30
89
67
22
22
45
50
23
48
17
46
38
29
42
25
47
20
46
31
19
21
42
27
22
66
21
23
66
75
74
46
21
46
19
69
20
20
48
23
88
51
28
49
18
20
45
22
31
38
23
28
49
39

 

Standard deviation: 

Variance: 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill