Description
Go to carmax.com and search for the make, model and year of your vehicle. Record the asking price and mileage of the first 10 vehicles.On the first worksheetType in your name and your vehicle information and your recorded data in the spaces provided.Rename the worksheet to your troy usernameOn the second worksheetDATA-Data Analytics-Descriptive Statistics (include Summary and 95% confidence Interval)Results in the blcok as indicatedCompute confidence intervals for population average asking price and average mileage On the last worksheetCreate a scatter plot of asking price VS mileageComment on the strength of the linear relationship between the two variables.
20171124003007_qm_2241_engagement_project.xlsx
QM 2241
Your troy username
Engagement Project
Last Name:
First Name:
Student ID:
Make:
Model:
Year:
Vehicle #
1
2
3
4
5
6
7
8
9
10
Asking Price ($)
Mileage (,000 miles)
20171124003007_qm_2241_engagement_project.xlsx
QM 2241
Population Average Vehicle asking Price
(
DESCRIPTIVE STATISTICS
,
Descriptive Statistics
Population Average Vehicle Mileage
)
(
,
)
20171124003007_qm_2241_engagement_project.xlsx
QM 2241
Scatter Plot of VEHICLE ASKING PRICE VS MILEAGE
(For review see Chapter 4)
Scatter Plot
Discussion of linear relationship between Vehicle
ASKING PRICE and MILEAGE.
Type your discussion here. Make the box deeper
if necessary.
20171124003007_qm_2241_engagement_project.xlsx
QM 2241
Scatter Plot
Purchase answer to see full
attachment