1. Can you determine the price of an airline ticket based upon the distance flown? The following data represents the miles flown and the dollars spent for the ticket. Test this hypothesis using simple regression. Include the output and your analysis.
Data Display 
Row Miles x Dollars y
1 1211 1802
2 1345 2405
3 1422 2005
4 1687 2511
5 1849 2332
6 2026 2305
7 2133 3016
8 2253 3385
9 2400 3090
10 2468 3694
11 2699 3371
12 2806 3998
13 3082 3555
14 3209 4692
15 3466 4244
16 3643 5298
17 3852 4801
18 4033 5147
19 4267 5738
20 4498 6420
21 4533 6059
22 4804 6426
23 5090 6321
24 5233 7026
25 5439 6964
2. Using the above model, if you were going to buy a ticket from Chicago to New York, how much would you expect to pay?
3. This is obviously concocted data. Use any site you wish to gather actual data to test this model. Run the regression and analyze your results. Be prepared to share your analysis with the class.
4. The following data are the average wine consumption rates (in liters per person) and the number ofischemic heart disease deaths (per 1000 men aged 55 to 64 years old) for 18 industrial countries. (Lancet, June 16, 1979) Does this data suggest that heart disease mortality is associated with average wine consumption? 
Data Display 
Heart
Disease
Row Wine Consumption Mortality
1 2.8 6.2
2 3.2 9.0
3 3.2 7.1
4 3.4 6.8
5 4.3 10.2
6 4.9 7.8
7 5.1 9.3
8 5.2 5.9
9 5.9 8.9
10 5.9 5.5
11 6.6 7.1
12 8.3 9.1
13 12.6 5.1
14 15.1 4.7
15 25.1 4.7
16 33.1 3.1
17 75.9 3.2
18 75.9 2.1

    • 12 years ago
    100% correct answer A++ work Guranteed the best Tutorial
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      8508624.xls