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.
Your troy username
Asking Price ($)
Mileage (,000 miles)
Population Average Vehicle asking Price
Population Average Vehicle Mileage
Scatter Plot of VEHICLE ASKING PRICE VS MILEAGE
(For review see Chapter 4)
Discussion of linear relationship between Vehicle
ASKING PRICE and MILEAGE.
Type your discussion here. Make the box deeper
Purchase answer to see full