Scribd
Upload
21 views

File 4

Uploaded by

Md. Ashiqur Rahman 2135050660
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
21 views

File 4

Uploaded by

Md. Ashiqur Rahman 2135050660
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 2
NORTH SOUTH UNIVERSITY MBA/EMBA PROGRAM. FALL- 2021 Course Title: Business Statistics Course Code: BUS-511 Assignment(Second Part) using IBM SPSS. Marks:30 First enter the Real Estate data into SPSS from the Excel Program you are supplied with. Assume the 105 homes is population. Select a sample of size and answer the following exerci Exercise-4 s using your sample data a) A recent article in The Daily Newspaper indicated that the mean selling price of the homes in the capital city is $357(thousand). Can we conclude that the mean selling price in the capital city is not different from$357(thousand)? Use the 0.05 significance 21 b) The same article reported that the mean size in the capital city was 3400 square feet. Can we conclude that the mean size of homes sold in the city area is not different from 3400 square feet? Use the 0.05 significance level. Ry [Note: Test using manual procedure and also using p-value for both (a) and (b)] Exercise a) At the .05 significance level, can we conclude that there is a difference in the mean selling price of homes with a pool and homes without a pool? [+2 | b) At the .05 significance level, can we conclude that there is a difference in the mean selling price of homes with an attached garage and homes without an attached garage? [Note: Test using manual procedure and also using p-value for both (a) and (b)] Exercise-6: At the .05 significance level, is there a difference in the mean selling price of the homes among the five township? [Note: Test using p-value only] G1 Could there be a significant difference among the pair of treatment means? Post Hoc Test. Multiple Comparison. [LSD] uu Exercise-7: a) Let selling price be the dependent variable and size of the home the independent variable. Bl Determine the regression equation and interpret. Write down the reression equation in words Estimate the selling price for home with an area of 2,200 square feet.Determine r, R? and S,,.. Interpret. b) Let selling price be the dependent variable and no. of bed rooms the independent variable. [4] Determine the regression equation and interpret. Determine r, R2 and S,, . Interpret. Estimate the selling price for home with 5 bedrooms. Exercise-8: se the selling price as the dependent variable and determine the regression equation with number of bedrooms, size of the house, whether there is a pool, whether there is an attached ‘garage, distance from the center of the city and number of bathrooms as independent variables. a) Write out the regression equation. Discuss each of the variables. (3) ‘Write down the regression equation in words. How much does a garage or a swimming pool adds to the selling price of a home? b) Determine the value of R-square. Interpret. 2 ) Determine the multiple S.E of the estimate and interpret. 12] 4) Conduct a global test on the set of independent variables. Interpret. (Note: Test using p-value only} eI] ©) Conduct a test of hypothesis on each of the independent variables. Would you consider deleting any of the variables? If so, which one? [Note: Test using p-value only) p] Date of submission: on or before — 31/12/2021(11:59 p.m).

You might also like