Week 2 Knowledge Check Homework Practice Questions Attempt 4- 95%
Attempt Score - 95 %
Overall Grade (Highest Attempt) - 95 %
Attempt 2 of 4
Written Jun 9, 2025 12:32 PM -Jun 9, 2025 1 :14 PM
Question 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
Calculate the third quartile. Round to two decimal places. Use the Excel function to find the Quartile. Third
Quartile:
___1922.75 ___
question 1 feedback
,use =QUARTILE.INC( , 3) function in Excel.
Question 2 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
Standard Deviation:
___167 ___
Calculate the standard deviation. Round to one decimal place. Use the Excel function to find the Sample SD.
Question 3 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 Mean:
___1811 ___ (1810.7)
Calculate the mean. Round to one decimal place. Use the Excel function to find the Average. Hide
question 3 feedback
, use =AVERAGE function in Excel
Question 4 point
A survey was conducted of 130 purchasers of new BMW 3 series cars, 130 purchasers of new BMW 5 series
cars, and 130 purchasers of new BMW 7 series cars. In it, people were asked the age they were when they
purchased their car. The following box plots display the results.
What is the interquartile range for the BMW 5 Series?
about 32 years
about 17 years
about 42 years
about 63 years
Attempt Score - 95 %
Overall Grade (Highest Attempt) - 95 %
Attempt 2 of 4
Written Jun 9, 2025 12:32 PM -Jun 9, 2025 1 :14 PM
Question 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
Calculate the third quartile. Round to two decimal places. Use the Excel function to find the Quartile. Third
Quartile:
___1922.75 ___
question 1 feedback
,use =QUARTILE.INC( , 3) function in Excel.
Question 2 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
Standard Deviation:
___167 ___
Calculate the standard deviation. Round to one decimal place. Use the Excel function to find the Sample SD.
Question 3 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 Mean:
___1811 ___ (1810.7)
Calculate the mean. Round to one decimal place. Use the Excel function to find the Average. Hide
question 3 feedback
, use =AVERAGE function in Excel
Question 4 point
A survey was conducted of 130 purchasers of new BMW 3 series cars, 130 purchasers of new BMW 5 series
cars, and 130 purchasers of new BMW 7 series cars. In it, people were asked the age they were when they
purchased their car. The following box plots display the results.
What is the interquartile range for the BMW 5 Series?
about 32 years
about 17 years
about 42 years
about 63 years
