of Bedrooms, # of Baths, and Age of a house on Selling Price by
running a Regression Analysis in MS Excel. (120 points)
a. Download the Analysis ToolPak
i. File -> Options -> Add Ins-> Go ->
Check 'Analysis Toolpak' -> Ok
b. Run the regression
i. Data -> Data Analysis ->
Regression
ii. Input Y Range $B$1:$B$4663
iii. Input X Range $C$1:$F$4663
iv. Check the Labels box then Click OK
c. Write a paragraph on what the Regression
means. Specifically, explain what the Coefficient and the P-value
means for each variable. (i.e. The P-value for Square feet means
that it significantly affects Price, and the Coefficient means for
each one Square foot increase the Price goes up $62.77.)
2. Provide Descriptive Statistics for each
variable. (30 points)
a. Data -> Data Analysis -> Descriptive
Statistics
b. Input Range $B$1:$F$4663
c. Check the Labels and Summary Statistics Boxes
then Click OK
CONTROL PRICE
SQFT BEDROOMS
BATHS AGE
18010001 34900 1100
3 2 20
18010002 27700 680
1 1 3
18010003 97000 770
1 2 19
18010004 61000 530
1 2 7
18010005 34900 990
1 2 15
18010006 41600 840
1 1 14
18010007 52000 1100
3 2 18
18010008 43000 780
1 2 1
18010009 61000 900
1 1 20
18010010 53000 1200
3 1 2
18010011 38900 1100
3 2 20
18010012 42900 1200
1 2 9
18010014 36900 980
3 1 8
18010016 42000 920
3 2 19
18010017 29400 710
1 1 20
18010018 48200 1200
3 2 12
18010020 53000 1200
3 1 15
18010021 40200 840
1 1 12
18010022 53000 1200
3 1 8
18010023 40300 920
3 1 16
18010025 44800 960
1 1 13
- 1 Determine The Effect Of Square Footage Of Bedrooms Of Baths And Age Of A House On Selling Price By Running 1 (69.56 KiB) Viewed 72 times
- 1 Determine The Effect Of Square Footage Of Bedrooms Of Baths And Age Of A House On Selling Price By Running 2 (62.98 KiB) Viewed 72 times
showed step by step.
viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing 1. Determine the effect of Square Footage, # of Bedrooms, # of Baths, and Age of a house on Selling Price by running a Regression Analysis in MS Excel. (120 points) a. Download the Analysis ToolPak i. File -> Options -> Add Ins-> Go-> Check 'Analysis Toolpak'> Ok b. Run the regression i. Data -> Data Analysis -> Regression ii. Input Y Range $B$1:$B$4663 iii. Input X Range $C$1:$F$4663 iv. Check the Labels box then click OK c. Write a paragraph on what the Regression means. Specifically, explain what the Coefficient and the P-value means for each variable. (i.e. The P-value for Square feet means that it significantly affects Price, and the Coefficient means for each one Square foot increase the Price goes up $62.77.) 2. Provide Descriptive Statistics for each variable. (30 points) a. Data -> Data Analysis -> Descriptive Statistics b. Input Range $B$1:$F$4663 c. Check the Labels and Summary Statistics Boxes then click OK D. FOC
D PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you neec H10 A B D F G AGE 20 3 19 2. 7 15 14 CONTROL PRICE SOFT 2 18010001 34900 3 18010002 27700 4 18010003 97000 5 18010004 61000 6 18010005 34900 7 18010006 41600 8 18010007 52000 9 18010008 43000 10 18010009 61000 11 18010010 53000 12 18010011 38900 13 18010012 42900 14 18010014 36900 15 18010016 42000 1513010017 29400 17 18010018 48200 18 13010020 53000 19 18010025 40200 2018010022 53000 2118010023 40300 22 12010025 Shooth BEDROOMS BATHS 1100 3 2 680 1 1 770 1 2 530 1 990 1 2 840 1 1 1100 3 2 780 1 2 900 1 1 1 1200 3 1100 3 1 980 3 920 3 710 1 1 1200 3 2 1200 3 1 840 1 1 1200 3 1 920 1 18 1 20 2 20 1200 9 8 19 20 12 15 12 8 10 13 1 Porn O