Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please the output must be from excel and I am unsure how to do that. Median Income and Median Home Price in Selected Eastern Cities

Please the output must be from excel and I am unsure how to do that.

Median Income and Median Home Price in Selected Eastern Cities (n = 34)
City Income Home
Alexandria, VA 59.976 290.000
Bernards Twp., NJ 112.435 279.900
Brentwood, TN 107.866 338.250
Bridgewater, NJ 93.484 316.000
Cary, NC 77.091 207.000
Centreville, VA 77.243 250.000
Chantilly, VA 94.864 320.000
Chesapeake, VA 53.758 150.000
Collierville, TN 85.716 230.000
Columbia, MD 77.033 199.000
Coral Springs, FL 62.632 218.500
Dranesville, VA 109.502 290.000
Dunwoody, GA 86.971 315.000
Ellicott City, MD 83.583 248.000
Franconia, VA 84.537 290.000
Gaithersburg, MD 64.944 220.000
Hoover, AL 64.431 170.450
Hunter Mill, VA 93.987 290.000
Lower Makefield Twp., PA 102.997 205.000
Manalapan Twp., NJ 91.245 410.000
Marlboro Twp., NJ 108.759 379.975
Matoaca, VA 65.149 135.000
Newtown, CT 97.723 358.500
North Andover, MA 79.169 342.500
Oakton, VA 90.824 341.000
Olney, MD 100.716 287.450
Peachtree City, GA 79.805 214.500
Ramapo, NY 64.954 330.875
Randolph Twp., NJ 104.121 444.500
Reston, VA 85.264 240.000
Roswell, GA 76.530 226.450
Sugarland Run, VA 103.350 278.250
Sully, VA 92.942 290.000
Wellington, FL 76.076 230.000

1) State your a priori hypothesis. Is it reasonable to suppose a cause-and-effect relationship?

2) Make a scatter plot of Y against X. Discuss what it tells you.

3) Use Excel's Add Trendline feature to fit a linear regression to the scatter plot. Is a linear model credible?

4) Use Excel to fit the regression model

5)Based on the R square and ANOVA table for your model, how would you assess the fit?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Econometrics

Authors: R Carter Hill, William E Griffiths, Guay C Lim

5th Edition

1118452275, 9781118452271

Students also viewed these Mathematics questions