The following data provided are the average hours fifty-six grade 8 students spent doing their homework every school week last school year 2020-2021. The lowest number of hours recorded is 5 hours (every 5 school days), and the highest is 34 hours. The table’s class interval is 5, and the mean is 18.9   HOURS FREQUENCY 5-9 3 10-14 8 15-19 23 20-24 11 25-29 9 20-24 2   Find the range Find the variance and standard deviation   excel file or with steps how to do it in excel

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
icon
Related questions
Question
  1. The following data provided are the average hours fifty-six grade 8 students spent doing their homework every school week last school year 2020-2021. The lowest number of hours recorded is 5 hours (every 5 school days), and the highest is 34 hours. The table’s class interval is 5, and the mean is 18.9

 

HOURS

FREQUENCY

5-9

3

10-14

8

15-19

23

20-24

11

25-29

9

20-24

2

 

  1. Find the range
  2. Find the variance and standard deviation

 

excel file or with steps how to do it in excel

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL