Question

In: Statistics and Probability

Continued from previous question. Price SQFT Bed Bath LTSZ 399900 5.026 4 4.5 0.3 375000 3.2...

Continued from previous question.

Price

SQFT

Bed

Bath

LTSZ

399900

5.026

4

4.5

0.3

375000

3.2

4

3

5

372000

3.22

5

3

5

370000

4.927

4

4

0.3

325000

3.904

3

3

1

325000

2.644

3

2.5

5

319500

5.318

3

2.5

2.5

312900

3.144

4

2.5

0.3

299900

2.8

4

3

5

294900

3.804

4

3.5

0.2

269000

3.312

5

3

1

250000

3.373

5

3.5

0.2

249900

3.46

2

2.5

0.6

244994

3.195

4

2.5

0.2

244900

2.914

3

3

0.3

239900

2.881

4

5

0.3

234900

1.772

3

2

3.6

234000

2.248

3

2.5

0.3

229900

3.12

5

2.5

0.2

219900

2.942

4

2.5

0.2

209900

3.332

4

2.5

0.2

209850

3.407

3

2.5

0.3

206900

2.092

3

2

0.3

200000

3.859

4

2

0.2

Solutions

Expert Solution

part 1 )

Price SQFT Bed Bath LTSZ
Mean 208789.320 2.598 3.560 2.490 0.818
Standard Deviation 79636.520 1.016 0.675 0.746 1.375

mean and standard deviation on each variable is above

you can generate by data-> data analysis -> descriptive statistics

check on summary statistics

for each variable

The statistical mean refers to the mean or average that is used to derive the central tendency of the data in question. It is determined by adding all the data points in a population and then dividing the total by the number of points.We derive the average and call as mean.

The standard deviation of a dataset gives you a measure of how spread out it is. On an average, it helps you ascertain how close each point is from the mean

for example average price is 208789.320

and sd of price is 79636.520

part 2)

using data -> data analysis -> regression

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.91940202
R Square 0.845300074
Adjusted R Square 0.83154897
Standard Error 32685.04673
Observations 50
ANOVA
df SS MS F Significance F
Regression 4 262682738715.9840 65670684678.9961 61.4714 0.0000
Residual 45 48074052582.8958 1068312279.6199
Total 49 310756791298.8800
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 23714.6259 25435.2663 0.9324 0.3561 -27514.6301
SQFT 44971.6764 6262.3653 7.1813 0.0000 32358.6252
Bed -5028.7156 7921.0849 -0.6349 0.5287 -20982.5995
Bath 26142.4324 8917.5724 2.9316 0.0053 8181.5196
LTSZ 25725.1240 3437.0852 7.4846 0.0000 18802.4790

Please rate

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Continued from previous question. Price SQFT Bed Bath LTSZ 399900 5.026 4 4.5 0.3 375000 3.2...
Continued from previous question. Price SQFT Bed Bath LTSZ 399900 5.026 4 4.5 0.3 375000 3.2 4 3 5 372000 3.22 5 3 5 370000 4.927 4 4 0.3 325000 3.904 3 3 1 325000 2.644 3 2.5 5 319500 5.318 3 2.5 2.5 312900 3.144 4 2.5 0.3 299900 2.8 4 3 5 294900 3.804 4 3.5 0.2 269000 3.312 5 3 1 250000 3.373 5 3.5 0.2 249900 3.46 2 2.5 0.6 244994 3.195 4 2.5 0.2 244900...
please don't copy from previous post and answer all Chapter 4 - Discussion Question (DQ) #...
please don't copy from previous post and answer all Chapter 4 - Discussion Question (DQ) # 2, 7, 11, 13, 21, 25, 30, 34 (DQ2) What is the difference between purchasing and strategic sourcing? (DQ7) In what ways is corporate social responsibility different from business ethics? (DQ11) What are the benefits of sustainable sourcing? Can firms actually make money from sustainable sourcing? Do you think it is a good practice? Why ? (DQ13) How could you apply sustainability to a...
Question 4-53 Use the information in the table on the previous page to allocate costs to...
Question 4-53 Use the information in the table on the previous page to allocate costs to the mission centers using the direct distribution method. Information in the Table Allocation Statistics Direct Purchasing: Administration Cost Centers Costs ($) Purchase Orders (%) Total Salaries (%) Support      Purchasing 80,000 5      Administration 40,000 15 - Mission -      Soup Kitchens 900,000 40 90      Counseling 300,000 45 5          Total Cost 1,320,000 100 100 Direct Distribution Method Soup Kitchen Counseling Purchasing Administration...
Question 3 3.1Explain what is meant by the term price elasticity of Supply(5 marks) 3.2 Use...
Question 3 3.1Explain what is meant by the term price elasticity of Supply 3.2 Use diagrams and examples explain the following three(3)Different categories of prices elasticity of Demand. 3.2.1. Unit elasticity demand 3.2.2.Relatively inelastic Demand (3marks) 3.2.3.Relatively elastic demand 3.3. list and explain an three(3)determinants of the price elasticity of demand
Inference from two independent samples. The data in the previous question (?̅ = 217,900, ? =...
Inference from two independent samples. The data in the previous question (?̅ = 217,900, ? = 91,200, ? = 25) was from 2013. The real estate agent believes that home prices have increased in the five years since then. In order to assess whether or not this is true, she gathers data on a new random sample of 40 existing single-family home sales from her neighborhood in 2018. The average sale price from her 2018 sample is ?̅ = 252,900...
Using the data set from the previous question (scatterplot.xlsx). With the data point with the smallest...
Using the data set from the previous question (scatterplot.xlsx). With the data point with the smallest x value removed, the scatter plot now suggests a ________   ["nonlinear" OR "linear"]         relationship between the dependent and independent variables. Data: x y 45 2358 56 4204 26 287 54 3849 24 925 23 3273 34 -678 45 3748 47 2898 43 1974 32 226
NB: Previous answer was rejected as it was a cut and paste from Google. Question: Explain...
NB: Previous answer was rejected as it was a cut and paste from Google. Question: Explain "Days of Inventory on Hand" and discuss the implications if the "Days of inventory on hand" show an increase annually ( 2 paragraphs answer) Days of Inventory on Hand 54.95 53.72 55.29 60.48 63.48 59.03 63.50 67.61 66.28 64.67 66.90
Using the data from the previous question on LDL cholesterol, you decide to test if the...
Using the data from the previous question on LDL cholesterol, you decide to test if the variance in LDL cholesterol of patients admitted to the hospital with a heart attack is the same as that of those who have not (the control). You use the R function var.test and obtain the following output.    F test to compare two variances data:  ldl.ha and ldl.cont F = 7.683, num df = 9, denom df = 15,    p-value = 0.0006501 alternative hypothesis:...
How to compute the question (b)? And why it isn't 6C2·0.3^2·0.7^4? The probability that Jim goes...
How to compute the question (b)? And why it isn't 6C2·0.3^2·0.7^4? The probability that Jim goes to work by taxi is 0.3. He works 6 days in a week. (a) Find the probability that Jim goes to work by taxi in at least 3 days in a week given that (i) he goes to work by taxi for at most 4 days, (ii) he goes to work by taxi for more than 1 day. (b) Find the probability that Jim...
How to compute the question (b)? And why it isn't 6C2·0.3^2·0.7^4? The probability that Jim goes...
How to compute the question (b)? And why it isn't 6C2·0.3^2·0.7^4? The probability that Jim goes to work by taxi is 0.3. He works 6 days in a week. (a) Find the probability that Jim goes to work by taxi in at least 3 days in a week given that (i) he goes to work by taxi for at most 4 days, (ii) he goes to work by taxi for more than 1 day. (b) Find the probability that Jim...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT