(a) Use statistical software to obtain a histogram. Do these house prices appear to be symmetrically...

(a) Use statistical software to obtain a histogram. Do these house prices appear to be symmetrically distributed? If not, in which direction do they seem to be skewed? (1.5 marks) (b) Run a quantile-quantile test of normality on “price” values to see if the data is normally distributed or not. (c) Computer µ and σ for the prices of all houses. (1.5 marks) (d) What percentage of these prices lie in the interval (µ - σ) to (µ + σ)? What about in the interval (µ -2σ) to (µ + 2σ)? In the interval (µ - 3σ) to (µ + 3σ)? (1.5 marks) (e) How do the percentage in part (c) compare to the corresponding percentage for a normal distribution (68.26%, 95.44%, and 99.74%, respectively)? (1.5 marks) (f) Select three random samples of 20 house prices each (make clusters of 20 samples each). Create a histogram for each cluster, and calculate the mean and standard deviation of the prices for each one. How well do your graphs and summary statistics match up with the corresponding population graphs and parameter values obtained in the earlier parts? Does it seem reasonable that they might not match very well? (1.5 marks) (g) Run the ANOVA test on whether the prices for all your three categories are the same or not. (h) Fit data in a linear model (dependent variable is price), independent variable could be whatever you think is suitable. Make two predictions for price based on your independent variable. (i) Grammar check, length (min 3 pages with 1000 words to the max of 4 pages with 1500 words), proper spacing with the APA format (1.5 mark) The format: (1) Write a report for answering part (a) to (h) above. The report must be in an essay format of APA style including graphs and calculations. Graphs and calculations should form an appendix which is attached at the end of your essay. Feel free to use any software or platform you would like if you are not comfortable with Excel. Use the 12 point font and 1.5 spacing.

Price	Bedrooms	Size	Pool	Distance	Twnship	Garage	Baths
263.1	4	2300	0	17	5	1	2
182.4	4	2100	1	19	4	0	2
242.1	3	2300	1	12	3	0	2
213.6	2	2200	1	16	2	0	2.5
139.9	2	2100	1	28	1	0	1.5
245.4	2	2100	0	12	1	1	2
327.2	6	2500	1	15	3	1	2
271.8	2	2100	1	9	2	1	2.5
221.1	3	2300	0	18	1	0	1.5
266.6	4	2400	1	13	4	1	2
292.4	4	2100	1	14	3	1	2
209	2	1700	1	8	4	1	1.5
270.8	6	2500	1	7	4	1	2
246.1	4	2100	1	18	3	1	2
194.4	2	2300	1	11	3	0	2
281.3	3	2100	1	16	2	1	2
172.7	4	2200	0	16	3	0	2
207.5	5	2300	0	21	4	0	2.5
198.9	3	2200	0	10	4	1	2
209.3	6	1900	0	15	4	1	2
252.3	4	2600	1	8	4	1	2
192.9	4	1900	0	14	2	1	2.5
209.3	5	2100	1	20	5	0	1.5
345.3	8	2600	1	9	4	1	2
326.3	6	2100	1	11	5	1	3
173.1	2	2200	0	21	5	1	1.5
187	2	1900	1	26	4	0	2
257.2	2	2100	1	9	4	1	2
233	3	2200	1	14	3	1	1.5
180.4	2	2000	1	11	5	0	2
234	2	1700	1	19	3	1	2
207.1	2	2000	1	11	5	1	2
247.7	5	2400	1	16	2	1	2
166.2	3	2000	0	16	2	1	2
177.1	2	1900	1	10	5	1	2
182.7	4	2000	0	14	4	0	2.5
216	4	2300	1	19	2	0	2
312.1	6	2600	1	7	5	1	2.5
199.8	3	2100	1	19	3	1	2
273.2	5	2200	1	16	2	1	3
206	3	2100	0	9	3	0	1.5
232.2	3	1900	0	16	1	1	1.5
198.3	4	2100	0	19	1	1	1.5
205.1	3	2000	0	20	4	0	2
175.6	4	2300	0	24	4	1	2
307.8	3	2400	0	21	2	1	3
269.2	5	2200	1	8	5	1	3
224.8	3	2200	1	17	1	1	2.5
171.6	3	2000	0	16	4	0	2
216.8	3	2200	1	15	1	1	2
192.6	6	2200	0	14	1	0	2
236.4	5	2200	1	20	3	1	2
172.4	3	2200	1	23	3	0	2
251.4	3	1900	1	12	2	1	2
246	6	2300	1	7	3	1	3
147.4	6	1700	0	12	1	0	2
176	4	2200	1	15	1	1	2
228.4	3	2300	1	17	5	1	1.5
166.5	3	1600	0	19	3	0	2.5
189.4	4	2200	1	24	1	1	2
312.1	7	2400	1	13	3	1	3
289.8	6	2000	1	21	3	1	3
269.9	5	2200	0	11	4	1	2.5
154.3	2	2000	1	13	2	0	2
222.1	2	2100	1	9	5	1	2
209.7	5	2200	0	13	2	1	2
190.9	3	2200	0	18	3	1	2
254.3	4	2500	0	15	3	1	2
207.5	3	2100	0	10	2	0	2
209.7	4	2200	0	19	2	1	2
294	2	2100	1	13	2	1	2.5
176.3	2	2000	0	17	3	0	2
294.3	7	2400	1	8	4	1	2
224	3	1900	0	6	1	1	2
125	2	1900	1	18	4	0	1.5
236.8	4	2600	0	17	5	1	2
164.1	4	2300	1	19	4	0	2
217.8	3	2500	1	12	3	0	2
192.2	2	2400	1	16	2	0	2.5
125.9	2	2400	1	28	1	0	1.5
220.9	2	2300	0	12	1	1	2
294.5	6	2700	1	15	3	1	2
244.6	2	2300	1	9	2	1	2.5
199	3	2500	0	18	1	0	1.5
240	4	2600	1	13	4	1	2
263.2	4	2300	1	14	3	1	2
188.1	2	1900	1	8	4	1	1.5
243.7	6	2700	1	7	4	1	2
221.5	4	2300	1	18	3	1	2
175	2	2500	1	11	3	0	2
253.2	3	2300	1	16	2	1	2
155.4	4	2400	0	16	3	0	2
186.7	5	2500	0	21	4	0	2.5
179	3	2400	0	10	4	1	2
188.3	6	2100	0	15	4	1	2
227.1	4	2900	1	8	4	1	2
173.6	4	2100	0	14	2	1	2.5
188.3	5	2300	1	20	5	0	1.5
310.8	8	2900	1	9	4	1	2
293.7	6	2400	1	11	5	1	3
179	3	2400	1	8	4	1	2
188.3	6	2100	0	14	2	1	2.5
227.1	4	2900	1	20	5	0	1.5
173.6	4	2100	1	9	4	1	2
188.3	5	2300	1	11	5	1	3

Expert Solution

Hope this was helpful. Please leave back any comment.

orchestra answered 1 year ago

a) Produce a histogram of the distribution of these prices. Comment on what this histogram reveals...

a) Produce a histogram of the distribution of these prices. Comment on what this histogram reveals about the distribution. [Be sure to relate your comments to the context, and refer to the shape, center, variability, and outliers (if any).] price 413 413 455 455 459 465 495 495 499 499 500 500 504 510 515 520 529 529 529 530 535 570 570 579 585 589 599 600 650 660 665 665 695 698 699 699 699 700 795 799...

A table of house pricing data is linked below. Use software to do further analyses with...

A table of house pricing data is linked below. Use software to do further analyses with the multiple regression model of y=selling price of home in thousands, x1=size of home, and x2=number of bedrooms. Then use this model to complete parts a through c below. Data: y_Price_($) x1_Size_(sq_ft) x2_Bedrooms 309900 3179 5 161700 1738 3 162100 1901 2 132100 996 1 210900 1676 2 170100 1662 2 189700 1396 2 286100 3627 4 304700 3961 5 252700 3395 5 120200 ...

Please provide statistical data on House prices after COVID-19 in Lower Mainland in Canada

A group of students gather at Raquel's house to do a statistical assignment. In this group...

A group of students gather at Raquel's house to do a statistical assignment. In this group there are 10 women and 8 men. Of the women 5 study Management and the rest Accounting, while of the men only one studies Management and the rest Accounting. a. If the first to arrive at the house are three girls, what is the probability that they will study the same? b. If any three of them make the assignment, what is the probability...

How is statistical software useful?

Power calculation for hypothesis testing are relatively easy to do with modern statistical software. What do...

Power calculation for hypothesis testing are relatively easy to do with modern statistical software. What do you think adequate power should be for an experiment? What issues need to be considered in answering the question?

Assume that you are working for a company that develops software systems for in-house use in...

Assume that you are working for a company that develops software systems for in-house use in its design of aircraft engines. Being a software engineer you may not have any expertise in aircraft engines. While testing programs for such applications, what are the challenges you are likely to face, and how will you overcome them?

Q3. Consider the matrix A . Use R statistical software to determine the eigenvalues and normalized...

Q3. Consider the matrix A . Use R statistical software to determine the eigenvalues and normalized eigenvectors of A, trace of A, determinant of A, and inverse of A. Also determine the eigenvalues and normalized eigenvectors of A-1. Your answer should include your R code (annotated with comments) and a hand-written or typed summary of the answers from the R output.

Use this sample of house prices and lot sizes in the Pelham Bay neighborhood of the...

Use this sample of house prices and lot sizes in the Pelham Bay neighborhood of the Bronx from 2018-2019 to answer the questions below. price lot size 490000 2503 512000 2483 345000 2500 508670 2900 550000 2513 300000 2513 995000 4950 920000 3135 470000 2375 450000 2375 What kind of data is this? For one of the series, and for 3 equally spaced non-overlapping intervals what in the interval size, the beginning, end and midpoint of each interval, the frequency,...

Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your...

Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your assignment. Tasks: 1.Select thirty stocks (at least 3 different industries) that are listed on the Toronto Stock Exchange. 2.Track each stock’s closing price at the end of the trading day. These closing prices will appear on the Internet. Collect the stock closing price data from January 2017 to December 2019. 4. For each stock, use your data to calculate and interpret: (show calculations) a)the...

Question