Statistics Help Please see attached files. If possible please use Megastat Excel Add-In to solve all...

Question

Statistics Help Please see attached files. If possible please use Megastat Excel Add-In to solve all problems and provide excel results and MS Word solutions

Document Preview:

Independent random samples of the selling prices of houses in four districts were taken. The selling prices (in thousands of dollars) are shown in the accompanying table. Test the null hypothesis that population mean selling prices are the same in all four districts. District ADistrict BDistrict CDistrict D7359766785868470976775806189707663847869 Three real estate agents were each asked to assess the values of five houses in a neighborhood. The results, in thousands of dollars, are given in the table. Prepare the analysis of variance table, and test the null hypothesis that population mean valuations are the same for the three real estate agents. AgentHouseABC12102182262192190198318318718542272232375242240237 Created with an evaluation copy of Aspose.Words. To discover the full versions of our APIs please visit: https://products.aspose.com/words/ Created with an evaluation copy of Aspose.Words. To discover the full versions of our APIs please visit: https://products.aspose.com/words/

Independent random samples of the selling prices of houses in four districts were taken. The selling prices (in thousands of dollars) are shown in the accompanying table. Test the null hypothesis that population mean selling prices are the same in all four districts. District A District B District C District D 73 59 76 67 85 86 84 70 97 67 75 80 61 89 70 76 63 84 78 69 Three real estate agents were each asked to assess the values of five houses in a neighborhood. The results, in thousands of dollars, are given in the table. Prepare the analysis of variance table, and test the null hypothesis that population mean valuations are the same for the three real estate agents. Agent House A B C 1 210 218 226 2 192 190 198 3 183 187 185 4 227 223 237 5 242 240 237

005_kg6cazo-dqn2mogb.docx

Robert · Accepted Answer

Q1) 
Independent random samples of the selling prices of houses in four districts were taken. The selling 
prices (in thousands of dollars) are shown in the accompanying table. Test the null hypothesis that 
population mean selling prices are the same in all four districts.  
District 
A
District 
B
District 
C
District 
D 
73 
 
59 
 
76 
 
67 
85 
 
86 
 
84 
 
70 
97 
 
67 
 
75 
 
80 
61 
 
89 
 
70 
 
76 
63 
 
84 
 
78 
 
69 
 
Assumptions: 
 Independence of cases 
 the distributions of the residuals are normal 
 Equality of variances, called homoscedasticity 
 
Analysis: 
Ho: there is no significant difference in the mean selling prices across 4 districts. 
H1: at least one of the mean selling prices across 4 districts differ significantly. 
With F = .192 and p-value > 0.05, I fail to reject ho and conclude that there is no significant difference in 
the mean selling prices across 4 districts.  
Hence here there is no need to apply Post Hoc analysis.
Output: 
ANOVA: Single Factor 
      
       SUMMARY 
      Groups Count Sum Average Variance 
  District A 5 379 75.8 231.2000 
  District B 5 385 77 174.5000 
  District C 5 383 76.6 25.8000 
  District D 5 362 72.4 29.

Statistics Help Please see attached files. If possible please use Megastat Excel Add-In to solve all problems and provide excel results and MS Word solutions Document Preview: Independent random...

Answer To: Statistics Help Please see attached files. If possible please use Megastat Excel Add-In to solve all...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment