I attached Data for each sectionBUSN 340 Business Statistics Final Project Assignment 1.) Refer to the real estate data in Blackboard.Determine whether there is a difference in the mean selling price of homes with an attached garage and homes without an attached garage. Homes with an attached garage Mean = Standard Deviation = Number = Mean = Standard Deviation = Number = Explain your conclusion: Homes without an attached garage H.)Describe from a Biblical worldview how a realtor can use this information to serve their clients. Support your views with biblical references. 2.)Refer to the GM car data in Blackboard which shows the number of cars (in millions) sold in the United States for various years and the percent of those cars manufactured by GM.Use a statistical software package to determine whether the number of cars sold is directly or indirectly related to GM’s percent of the market.Draw a scatter diagram to show you conclusion. 3.) Refer to the Real Estate data in Blackboard.Use the selling price of the home as the dependent variable and determine the regression equation with the numbers of bedrooms, size of the house, whether there is a pool, distance from the center of the city, township, whether there is an attached garage, and the number of bathrooms as independent variables. Write out the regression equation.How much does a garage or an extra bathroom add to the selling price of a home?Determine the value of R-squared.Provide an interpretation of the variance R-squared represents.Develop a correlation matrix.Which independent variables have strong or weak correlations with the dependent variable (price)?
gm_car_data_final_project.xlsx

real_estate_data_for_final_project.xlsx

Unformatted Attachment Preview

Year
1950
1955
1960
1965
1970
1975
1980
1985
1990
1995
2000
2005
Cars Sold (in millions)
6
7.8
7.3
10.3
10.1
10.8
11.5
15.4
13.5
15.5
17.4
16.9
Percent GM
50.2
50.4
44
49.9
39.5
43.1
44
40.1
36
31.7
28.6
26.9
Price
245.400
221.100
232.200
198.300
192.600
147.400
224.000
220.900
199.000
139.900
224.800
216.800
176.000
189.400
125.900
192.900
166.200
307.800
209.700
207.500
209.700
173.600
188.300
213.600
271.800
281.300
247.700
216.000
273.200
251.400
154.300
294.000
192.200
244.600
253.200
172.700
206.000
166.500
190.900
254.300
176.300
155.400
242.100
Bedrooms
2
3
3
4
6
6
3
2
3
2
3
3
4
4
2
4
3
3
5
3
4
4
6
2
2
3
5
4
5
3
2
2
2
2
3
4
3
3
3
4
2
4
3
Square Feet
2100
2300
1900
2100
2200
1700
1900
2300
2500
2100
2200
2200
2200
2200
2400
1900
2000
2400
2200
2100
2200
2100
2100
2200
2100
2100
2400
2300
2200
1900
2000
2100
2400
2300
2300
2200
2100
1600
2200
2500
2000
2400
2300
Pool Distance Township Garage Baths
0
12
1
1
2
0
18
1
0
1,5
0
16
1
1
1,5
0
19
1
1
1,5
0
14
1
0
2
0
12
1
0
2
0
6
1
1
2
0
12
1
1
2
0
18
1
0
1,5
1
28
1
0
1,5
1
17
1
1
2,5
1
15
1
1
2
1
15
1
1
2
1
24
1
1
2
1
28
1
0
1,5
0
14
2
1
2,5
0
16
2
1
2
0
21
2
1
3
0
13
2
1
2
0
10
2
0
2
0
19
2
1
2
0
14
2
1
2,5
0
14
2
1
2,5
1
16
2
0
2,5
1
9
2
1
2,5
1
16
2
1
2
1
16
2
1
2
1
19
2
0
2
1
16
2
1
3
1
12
2
1
2
1
13
2
0
2
1
13
2
1
2,5
1
16
2
0
2,5
1
9
2
1
2,5
1
16
2
1
2
0
16
3
0
2
0
9
3
0
1,5
0
19
3
0
2,5
0
18
3
1
2
0
15
3
1
2
0
17
3
0
2
0
16
3
0
2
1
12
3
0
2
327.200
292.400
246.100
194.400
233.000
234.000
199.800
236.400
172.400
246.000
312.100
289.800
217.800
294.500
263.200
221.500
175.000
207.500
198.900
209.300
182.700
205.100
175.600
171.600
269.900
186.700
179.000
188.300
182.400
266.600
209.000
270.800
252.300
345.300
187.000
257.200
294.300
125.000
164.100
240.000
188.100
243.700
227.100
310.800
6
4
4
2
3
2
3
5
3
6
7
6
3
6
4
4
2
5
3
6
4
3
4
3
5
5
3
6
4
4
2
6
4
8
2
2
7
2
4
4
2
6
4
8
2500
2100
2100
2300
2200
1700
2100
2200
2200
2300
2400
2000
2500
2700
2300
2300
2500
2300
2200
1900
2000
2000
2300
2000
2200
2500
2400
2100
2100
2400
1700
2500
2600
2600
1900
2100
2400
1900
2300
2600
1900
2700
2900
2900
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
15
14
18
11
14
19
19
20
23
7
13
21
12
15
14
18
11
21
10
15
14
20
24
16
11
21
10
15
19
13
8
7
8
9
26
9
8
18
19
13
8
7
8
9
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
1
1
1
0
1
1
1
1
0
1
1
1
0
1
1
1
0
0
1
1
0
0
1
0
1
0
1
1
0
1
1
1
1
1
0
1
1
0
0
1
1
1
1
1
2
2
2
2
1,5
2
2
2
2
3
3
3
2
2
2
2
2
2,5
2
2
2,5
2
2
2
2,5
2,5
2
2
2
2
1,5
2
2
2
2
2
2
1,5
2
2
1,5
2
2
2
179.000
173.600
263.100
173.100
236.800
209.300
326.300
180.400
207.100
177.100
312.100
269.200
228.400
222.100
188.300
293.700
227.100
188.300
3
4
4
2
4
5
6
2
2
2
6
5
3
2
5
6
4
5
2400
2100
2300
2200
2600
2100
2100
2000
2000
1900
2600
2200
2300
2100
2300
2400
2900
2300
1
1
0
0
0
1
1
1
1
1
1
1
1
1
1
1
1
1
8
9
17
21
17
20
11
11
11
10
7
8
17
9
20
11
20
11
4
4
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
1
1
1
1
1
0
1
0
1
1
1
1
1
1
0
1
0
1
2
2
2
1,5
2
1,5
3
2
2
2
2,5
3
1,5
2
1,5
3
1,5
3

Purchase answer to see full
attachment