The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (X) and the average amount spent on entertainment (Y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation y = 17.49 + 1.0334x. For these data SSE = 1541.4. Use Table 1 of Appendix B. (NEED ANSWER FOR A) a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals). The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provideinsights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows theaverage daily hotel room rate (x) and the average amount spent on entertainment (y) for a random sample of 9 of the 25 most-visited U.S. cities. Thesedata lead to the estimated regression equation ŷ = 17.49 + 1.0334x. For these data SSE = 1541.4. Click on the datafile logo to reference the data. UseTable 1 of Appendix B.DATA fileRoom Rate EntertainmentCity($)(s)Boston148161Denver96105Nashville91101New Orleans110142Phoenix90100San Diego102120San Francisco1361670682San Jose140Tampa98a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals).b. Develop a 95% confidence interval for the mean amount spent on entertainment for all cities that have a daily room rate of $89 (to 2 decimals).$128 to $ 149.77c. The average room rate in Chicago is $128. Develop a 95% prediction interval for the amount spent on entertainment in Chicago (to 2 decimals).$ 110.69 to $ 188.84 TABLE 4 F DISTRIBUTIONArea orprobabilityF.Entries in the table give Fa values, where a is the area or probability in the upper tail of the F distribution. For example, with 4 numerator degrees of freedom,8 denominator degrees of freedom, and a .05 area in the upper tail, F9s = 3.84.Denominat torArea inNumerator Degrees of Free domDegreesof Freed omUpperTail123.56.71015202530406010010039.8659.86240.54.1049.5053.5955.8357.2458.2058.9159.4460.1961.2261.7462.0562.2662.5362.79630163.3005161.45199.50215.71224.58230.16233.99236.77238.88241.88245.95248.02249.26250.10251.14252.20253.04254.19984.871005.606286.43025647.79799.48864.15899.60921.83937.11948.20956.64963.28968.63993.08998.091001 401009.791013.166333.921017.764052.18 4999.34 5403.53 5624.26 5763.96 5858.95 5928.335980.95 6022.40 6055.93 6156.976208.666239.866260.356312.976362.80108.539.009.169.249.299.339.359.379.389.399.429,449.459.469,479479.489.4905185119.0019.1619.2519.3019.3319.3519.3719.3819.40194319,4519.4619.4619,4719.48194919.4902538.5139,0039,1739.2539.3039.3339.3639.3739.3939,4039.4339.4539 4639.4639,4739 4839.4939.500198.50990099.1699.2599.3099.3399.3699.3899.3999,40994399.4599,4699,4799,4899 4899,4999.50.105.545.465,395.345.315,285.275.255.245.235.205. 185,175,175. 165.155.145.130510.139.559.289.129.018.948.898.858.818.798,708,668.638,628,598.578.558.5302517.4416.0415.4415.1014.8814,7314.6214.5414,4714.4214.2514.1714.1214.0814.0413.9913.9613.910134.1230.8229.4628.7128.2427.9127.6727.4927.3427.2326.8726.6926.5826.5026.4126.3226.2426.14.104.544.324.194.114.054.013.983.953.943.923.873.843.833.823.803.793.783.76057.716.946.596.396.266.166.096.046.005.965.865.805.775.755.725.695.665.6302512.2210.659.989.609.369.209.078,988.908.848.668.568.508.468.418.368.328.26.0121.2018.0016.6913.9815.5215.2114.9814.8014.6614.5514.2014.0213.9113.8413.7513.6513.5813.47.10.054.063,783.623.523.453,403.373.343.323,303,3243.213.193.173.163.143. 133.116.61.5.795.415. 195.064.954, 884,824.774.744.624.564.524.504,464,434,414,377.397. 1510.9702510,018.437,766,986.856.766,686,626,436.336.276.236.186.126.086,02.0116.2613.2712.0611.3910.6710.4610.2910. 1610.059.729.559459.389.299.209.139.03

a) Given regression equation is Y=17.49+1.0334X.

Answered: The Wall Street Journal asked Concur…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (X) and the average amount spent on entertainment (Y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation y = 17.49 + 1.0334x. For these data SSE = 1541.4. Use Table 1 of Appendix B.

(NEED ANSWER FOR A)

a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals).

Transcribed Image Text:The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate (x) and the average amount spent on entertainment (y) for a random sample of 9 of the 25 most-visited U.S. cities. These data lead to the estimated regression equation ŷ = 17.49 + 1.0334x. For these data SSE = 1541.4. Click on the datafile logo to reference the data. Use Table 1 of Appendix B. DATA file Room Rate Entertainment City ($) (s) Boston 148 161 Denver 96 105 Nashville 91 101 New Orleans 110 142 Phoenix 90 100 San Diego 102 120 San Francisco 136 167 06 82 San Jose 140 Tampa 98 a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals). b. Develop a 95% confidence interval for the mean amount spent on entertainment for all cities that have a daily room rate of $89 (to 2 decimals). $ 128 to $ 149.77 c. The average room rate in Chicago is $128. Develop a 95% prediction interval for the amount spent on entertainment in Chicago (to 2 decimals). $ 110.69 to $ 188.84

TABLE 4 F DISTRIBUTION
Area or
probability
F.
Entries in the table give Fa values, where a is the area or probability in the upper tail of the F distribution. For example, with 4 numerator degrees of freedom,
8 denominator degrees of freedom, and a .05 area in the upper tail, F9s = 3.84.
Denominat tor
Area in
Numerator Degrees of Free dom
Degrees
of Freed om
Upper
Tail
1
2
3.
5
6.
7
10
15
20
25
30
40
60
100
100
39.86
59.86
240.54
.10
49.50
53.59
55.83
57.24
58.20
58.91
59.44
60.19
61.22
61.74
62.05
62.26
62.53
62.79
6301
63.30
05
161.45
199.50
215.71
224.58
230.16
233.99
236.77
238.88
241.88
245.95
248.02
249.26
250.10
251.14
252.20
253.04
254.19
984.87
1005.60
6286.43
025
647.79
799.48
864.15
899.60
921.83
937.11
948.20
956.64
963.28
968.63
993.08
998.09
1001 40
1009.79
1013.16
6333.92
1017.76
4052.18 4999.34 5403.53 5624.26 5763.96 5858.95 5928.33
5980.95 6022.40 6055.93 6156.97
6208.66
6239.86
6260.35
6312.97
6362.80
10
8.53
9.00
9.16
9.24
9.29
9.33
9.35
9.37
9.38
9.39
9.42
9,44
9.45
9.46
9,47
947
9.48
9.49
05
1851
19.00
19.16
19.25
19.30
19.33
19.35
19.37
19.38
19.40
1943
19,45
19.46
19.46
19,47
19.48
1949
19.49
025
38.51
39,00
39,17
39.25
39.30
39.33
39.36
39.37
39.39
39,40
39.43
39.45
39 46
39.46
39,47
39 48
39.49
39.50
01
98.50
9900
99.16
99.25
99.30
99.33
99.36
99.38
99.39
99,40
9943
99.45
99,46
99,47
99,48
99 48
99,49
99.50
.10
5.54
5.46
5,39
5.34
5.31
5,28
5.27
5.25
5.24
5.23
5.20
5. 18
5,17
5,17
5. 16
5.15
5.14
5.13
05
10.13
9.55
9.28
9.12
9.01
8.94
8.89
8.85
8.81
8.79
8,70
8,66
8.63
8,62
8,59
8.57
8.55
8.53
025
17.44
16.04
15.44
15.10
14.88
14,73
14.62
14.54
14,47
14.42
14.25
14.17
14.12
14.08
14.04
13.99
13.96
13.91
01
34.12
30.82
29.46
28.71
28.24
27.91
27.67
27.49
27.34
27.23
26.87
26.69
26.58
26.50
26.41
26.32
26.24
26.14
.10
4.54
4.32
4.19
4.11
4.05
4.01
3.98
3.95
3.94
3.92
3.87
3.84
3.83
3.82
3.80
3.79
3.78
3.76
05
7.71
6.94
6.59
6.39
6.26
6.16
6.09
6.04
6.00
5.96
5.86
5.80
5.77
5.75
5.72
5.69
5.66
5.63
025
12.22
10.65
9.98
9.60
9.36
9.20
9.07
8,98
8.90
8.84
8.66
8.56
8.50
8.46
8.41
8.36
8.32
8.26
.01
21.20
18.00
16.69
13.98
15.52
15.21
14.98
14.80
14.66
14.55
14.20
14.02
13.91
13.84
13.75
13.65
13.58
13.47
.10
.05
4.06
3,78
3.62
3.52
3.45
3,40
3.37
3.34
3.32
3,30
3,324
3.21
3.19
3.17
3.16
3.14
3. 13
3.11
6.61.
5.79
5.41
5. 19
5.06
4.95
4, 88
4,82
4.77
4.74
4.62
4.56
4.52
4.50
4,46
4,43
4,41
4,37
7.39
7. 15
10.97
025
10,01
8.43
7,76
6,98
6.85
6.76
6,68
6,62
6,43
6.33
6.27
6.23
6.18
6.12
6.08
6,02
.01
16.26
13.27
12.06
11.39
10.67
10.46
10.29
10. 16
10.05
9.72
9.55
945
9.38
9.29
9.20
9.13
9.03

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Research Ethics$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.