2 out of 2
Exam Actual points
Questions and
Answers/100%
Correct
Question 1
You will need the data contained in various worksheets of this Excel file as you
complete the exam: Data file for students.xlsx
Midwest Auto Sales has the following inventory. Use the data to answer Questions 1 – 4.
Quantit Safet
Auto ID Make Color Retail Price y y
Availabl Ratin
e g
1171 Chevy Blue $24,139.00 4 2
2792 Ford Red $20,874.00 29 5
2262 Ford Green $24,547.00 15 3
2552 Ford Green $24,568.00 21 1
2247 Honda Blue $20,733.00 6 3
1335 Chevy Blue $21,626.00 29 1
2916 Chevy Red $22,621.00 20 3
1803 Chevy Green $22,394.00 30 1
2380 Ford Green $27,404.00 8 4
1015 Ford Blue $20,775.00 11 3
1980 Ford Blue $22,117.00 11 3
1762 Honda Red $20,621.00 12 3
1054 Chevy Green $28,423.00 18 4
2283 Chevy Green $28,936.00 25 3
2966 Honda Blue $27,270.00 21 2
“Auto ID” is measured as a(n) variable.
Selecte
d C.
Answer Nominal
:
Answers: A.
Ordinal
B.
,Interval
C.
Nominal
D.
Undefi
n ed
,• Question 2
0 out of 2
For data in Q1, how many data variables are points
quantitative?
Selected
A. Answer: 1
Answers: A.
1
B.
2
C.
3
D.
4
• Question 3
2 out of 2
For data in Q1, “Quantity Available” is measured as a(n) points
variable.
Selecte
d A.
Answer Ratio
:
Answers: A.
Ratio
B.
Inter
v al
C.
Nomi
n al
D.
Ordin
al
• Question 4
2 out of 2
For data in Q1, “Safety Rating” is measured as a(n) points
variable.
Selecte
d D.
Answer Ordinal
:
Answers: A.
Ratio
B.
Unkn
o wn
, C.
Interval
D.