I need this statics project. I copied the instructions below and I attached the data and instructions. BUSN 340 Business Statistics Major Project Assignment 1.) Refer to the real estate data in Blackboard, which reports information on homes sold in the Phoenix, Arizona, area during the last year.Organize the data by the number of bedrooms into a frequency distribution. A.) What is the typical number (average) of bedrooms? B.) What are the fewest (minimum) and the most (maximum) number of bedrooms offered in the market? 2.) Sort the real estate data into a table that shows the number of homes that have a garage attached versus those that do not have a garage in each of the five townships.If a home is selected at random, compute the following probabilities. A.) The home has a garage attached. B.) Given that it is in Township 5, that it does not have a garage attached. C.) The home has a garage attached and is in Township 3. 3.) Refer to the real estate data and develop the following confidence intervals using statistical software.(Minitab: Stat – Basic Statistics – Graphical Summary – Select variable, then enter a 95% Confidence Interval). Develop a 95 percent confidence interval for the mean selling price of the homes.Develop a 95 percent confidence interval for the mean distance the home is from the center of the city. 4.) Refer to the baseball data in Blackboard, which reports information on 30 major league teams for the 2008 baseball season.Select the variable that refers to the seating capacity (size) of the stadium.Find the mean, median, mode and the standard deviation. 5.) Refer to the baseball data in Blackboard.Assume the seating capacity (size) represents the population.Develop a histogram of the data.Would it seem reasonable from this histogram to conclude that the seating capacity population follows the normal distribution? 6.) Refer to the wage data, which report information on annual wages for a sample of 100 workers.Also included are variables relating to industry, years of education, and gender for each worker.(Minitab: Graph – Box plot – One y Simple – select variable) Develop a box plot for the variable annual wage.Are there any outliers?Briefly explain your findings.Develop a box plot for the variable years of education.Are there any outliers?Briefly explain your findings.
real_estate_data_4_for_week_5_major_project.xlsx
busn_340_statistics_major_project_1__2.docx
Unformatted Attachment Preview
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
BUSN 340 Business Statistics
Major Project Assignment
1.) Refer to the real estate data in Blackboard, which reports information on homes
sold in the Phoenix, Arizona, area during the last year. Organize the data by the
number of bedrooms into a frequency distribution.
A.) What is the typical number (average) of bedrooms?
B.) What are the fewest (minimum) and the most (maximum) number of
bedrooms offered in the market?
2.) Sort the real estate data into a table that shows the number of homes that have a
garage attached versus those that do not have a garage in each of the five townships.
If a home is selected at random, compute the following probabilities.
A.) The home has a garage attached.
B.) Given that it is in Township 5, that it does not have a garage attached.
C.) The home has a garage attached and is in Township 3.
3.) Refer to the real estate data and develop the following confidence intervals using
statistical software. (Minitab: Stat – Basic Statistics – Graphical Summary – Select
variable, then enter a 95% Confidence Interval).
A.) Develop a 95 percent confidence interval for the mean selling price of the
homes.
B.) Develop a 95 percent confidence interval for the mean distance the home
is from the center of the city.
4.) Refer to the baseball data in Blackboard, which reports information on 30 major
league teams for the 2008 baseball season. Select the variable that refers to the
seating capacity (size) of the stadium. Find the mean, median, mode and the
standard deviation.
5.) Refer to the baseball data in Blackboard. Assume the seating capacity (size)
represents the population. Develop a histogram of the data. Would it seem
reasonable from this histogram to conclude that the seating capacity population
follows the normal distribution?
1
6.) Refer to the wage data, which report information on annual wages for a sample
of 100 workers. Also included are variables relating to industry, years of education,
and gender for each worker. (Minitab: Graph – Box plot – One y Simple – select
variable)
A.) Develop a box plot for the variable annual wage. Are there any outliers?
Briefly explain your findings.
B.) Develop a box plot for the variable years of education. Are there any
outliers? Briefly explain your findings.
2
…
Purchase answer to see full
attachment
Recent Comments