Question

Done Car Value Dataset age price 6 8052.7 4.6 8838.25 2. 9 11535.8 4.2 9936.56 9.2 6744.53 2.3 12867.39 9 5952.4 4 9426.85 3.
In the SHSU Online folder named Car Value Example, you will find an Microsoft Excel file named Car Value Dataset.xlsx. Th
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.) Average age= [6+ 4.6+2.9 +4.2+9.2+2.3+9+4+3.2+6.8+7.6+1.6+10.3+6.8+4.6+10.4+2.1+9.6+9.2+8.7+2.3+8.8+9.3+10.6+4.7+5+

2.7+5+3.2+8.6]/30=6.11

Average price of sample = [8052.7+8838.25+11535.8+9936.56+6744.53+12867.39+5952.4+9426.85+10764.8+6965.94+7225.59+16292.48+6358.96+7245.94+9032.25+5302.26+13414.57+5537.57+6719.53+5958.5+12732.39+ 5943.07+6709.59+5784.29+8570.02+9088.46+12813.1+9323.46+10816.8+6046.68]\30

=8733.35

2.) Standard deviation of age =√ (1/30×standard deviation 2)-mean​​2

=√45.688-37.3321=√8.3559=2.8906

Standard deviation of price of sample =√(84090508.19-76271402.22)=2796.266

​​​​​​4.)a.) a is here constant. To linearise the above equation we use a and k.

b.)k is also here constant.

Add a comment
Know the answer?
Add Answer to:
Done Car Value Dataset age price 6 8052.7 4.6 8838.25 2. 9 11535.8 4.2 9936.56 9.2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • CAR 1 2 3 4 5 6 7 8 9 10 11 12 AGE 13 10...

    CAR 1 2 3 4 5 6 7 8 9 10 11 12 AGE 13 10 15 17 11 10 11 15 15 17 8 8 PRICE 13.1 11.8 5.7 4.9 6.8 14.0 11.4 9.8 9.8 4.5 13.0 11.0 Listed above is random sample of 12 used cars sold at the dealership during the last year. A. Determine the regression equation? a = b = B. Estimate the selling price of an 7-year old car ($000) selling price? C. Interpret...

  • 3-The population in the city of Houston from 1900 to 2010 is given below: Year Population...

    3-The population in the city of Houston from 1900 to 2010 is given below: Year Population 1900 44,633 1910 78,800 1920 138,276 1930 292,352 1940 384,514 1950 596,163 1960 938,219 1970 1,233,505 1980 1,595,138 1990 1,631,766 2000 1,953,631 2010 2,100,263 a. Give a scatter-plot and residual plot of the data. b. Based on the graphs in part a, propose a model for the data. Show me evidence to support your conclusion. Go through all necessary steps to construct a model...

  • (I did this homework in completion but professor was not happy with answers whatsoever, need additional...

    (I did this homework in completion but professor was not happy with answers whatsoever, need additional answers and especially improvement to 1.b help!! photos not attaching? mean by severai steps. inis is a View Feedback homework and will need you to work, in one two View Feedback or various steps. Unfortunately, I cannot read your screen shot of what you did on excel. As I have said in numerous messages announcements etc, I cannot аcсept pictures. You need to write...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT