MATH 302 WEEK 2 TEST | QUESTIONS AND ANSWERS | LATEST 2025/2026
UPDATE | 100% CORRECT - AMERICAN PUBLIC UNIVERSITY x
Your work has been saved and submitted
Written Jun 14, 2025 3:22 PM - Jun 14, 2025 3:52 PM Attempt 1 of 2
Attempt Score
Overall Grade (Highest Attempt)
Question 1 O/ 1 point
The population FTES for 2005—2006 through 2010—2011 was given in an updated report. The data are reported
here.
See Attached Excel for Data.
FTES data.xlsx
Use the Excel function to find the First Quartile
First Quartile:
1814.5 (1702.5) Calculate the first quartile. Round to one decimal place.
v Question 1 feedback
use -QUARTILE.INC( , 1) function in Excel.
Question 2 point
An instructor wants to compare spread (variation) of final grades of students in her online class and face-to-face
class. The instructor selects 10 students randomly from each class and the following table shows the final grades
of those students.
See Attached Excel for Data.
final grade data.xlsx
Use the Excel function to find the Sample SD. The standard deviation of final grades for the online class is
, 7.83 _ Use the information to respond to the following question: (round to 2 decimal places)
v Question 2 feedback
use =STEDV.S function in Excel.
Question 3 point
Twenty-five randomly selected students were asked the number of movies they watched the previous week. The results are as
follows:
See Attached Excel for Data.
movie data.xlsx
Find the approximate sample standard deviation, s. Use the Excelfunction to find the Sample SD.
Round to two decimal places.
_ 1.12
v Question 3 feedback
use =STDEV.S function in Excel.
Question 4 point
Santa Clara County, CA, has approximately 27,873 Japanese-Americans. Their ages are as follows :
Age Group Percent of Community
0-17 18.9
18-24 8.0
25-34 22.8
35-44
15.0
45-54
13.1
55-64 11.9
65+ 10.3
Which box plot most resembles the information above?
UPDATE | 100% CORRECT - AMERICAN PUBLIC UNIVERSITY x
Your work has been saved and submitted
Written Jun 14, 2025 3:22 PM - Jun 14, 2025 3:52 PM Attempt 1 of 2
Attempt Score
Overall Grade (Highest Attempt)
Question 1 O/ 1 point
The population FTES for 2005—2006 through 2010—2011 was given in an updated report. The data are reported
here.
See Attached Excel for Data.
FTES data.xlsx
Use the Excel function to find the First Quartile
First Quartile:
1814.5 (1702.5) Calculate the first quartile. Round to one decimal place.
v Question 1 feedback
use -QUARTILE.INC( , 1) function in Excel.
Question 2 point
An instructor wants to compare spread (variation) of final grades of students in her online class and face-to-face
class. The instructor selects 10 students randomly from each class and the following table shows the final grades
of those students.
See Attached Excel for Data.
final grade data.xlsx
Use the Excel function to find the Sample SD. The standard deviation of final grades for the online class is
, 7.83 _ Use the information to respond to the following question: (round to 2 decimal places)
v Question 2 feedback
use =STEDV.S function in Excel.
Question 3 point
Twenty-five randomly selected students were asked the number of movies they watched the previous week. The results are as
follows:
See Attached Excel for Data.
movie data.xlsx
Find the approximate sample standard deviation, s. Use the Excelfunction to find the Sample SD.
Round to two decimal places.
_ 1.12
v Question 3 feedback
use =STDEV.S function in Excel.
Question 4 point
Santa Clara County, CA, has approximately 27,873 Japanese-Americans. Their ages are as follows :
Age Group Percent of Community
0-17 18.9
18-24 8.0
25-34 22.8
35-44
15.0
45-54
13.1
55-64 11.9
65+ 10.3
Which box plot most resembles the information above?
