A number of people living in Toronto have been selected in order to study the re

Question

A number of people living in Toronto have been selected in order to study the relationship between family income and number of vacation days. The data are as follows: Sample Number Family income Vacation days ($) 1 48000 7 2 55000 9 3 87000 15 4 96000 15 5 103000 19 6 141000 25 7 166000 25 8 182000 30 9 228000 33 10 320000 25 11 358000 25 12 393000 21 13 475000 15 14 532000 14 15 614000 14 16 710000 12 a) Using EXCEL, develop a suitable model (using a polynomial expression), tabulate the model predictions, and compare them to the raw data. b) Using either the formulae provided in the lectures or the ANOVA Single Factor in the Data Analysis Pack of EXCEL, establish whether we can be statistically confident with a 95% probability that there are no differences between the model and the data (i.e. whether the model is really good). Now, the same study has been carried out with a population sample in London. The data are as follows: Sample number Family income Vacation days ($) 1 29000 12 2 54000 14 3 80000 21 4 98000 21 5 135000 30 6 148000 35 7 173000 35 8 220000 34 9 270000 35 10 365000 35 11 430000 40 12 475000 35 c) If we were to apply the model developed with the data gathered in Toronto to model the data of the London sample, how good would be the fit? Can you be statistically confident with a 95% probability that there are no differences between the model predictions and the data?

Explanation / Answer

Please rate me. I am not able to post your answer here. dont know why. But i am giving the link. If you have doubts please ask me. But please do not give poor rating

https://dl.dropbox.com/u/80779051/Part 1.JPG

https://dl.dropbox.com/u/80779051/Part 2.JPG

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.