Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company named Bubba's Web hosting provides two tiers of web hosting service accounts (an upper tier and a lower tier). The file named WebHostingSales.xlsx

A company named Bubba's Web hosting provides two tiers of web hosting service accounts (an upper tier and a lower tier). The file named WebHostingSales.xlsx contains the data for the number of upper tier hosting accounts, the number of lower tier hosting accounts and total monthly sales dollars for 48 consecutive months. Use linear regression to determine the monthly rate (in dollars) for the upper tier and the monthly rate (in dollars) for the lower tier. Upper tier rate ($/month): ________________________ Lower tier rate ($/month): ________________________ Attach a scanned copy of the regression analysis output from the spreadsheet.

Month LowerTier UpperTier SalesDollars
1 70 147 $1,421.00
2 160 82 $1,216.00
3 0 109 $872.00
4 400 100 $2,200.00
5 38 88 $837.00
6 43 98 $934.50
7 400 26 $1,608.00
8 0 169 $1,352.00
9 150 83 $1,189.00
10 344 131 $2,252.00
11 226 120 $1,751.00
12 508 129 $2,810.00
13 75 132 $1,318.50
14 28 0 $98.00
15 8 101 $836.00
16 126 166 $1,769.00
17 157 39 $861.50
18 382 209 $3,009.00
19 123 108 $1,294.50
20 632 98 $2,996.00
21 131 64 $970.50
22 543 97 $2,676.50
23 468 81 $2,286.00
24 145 6 $555.50
25 361 207 $2,919.50
26 84 159 $1,566.00
27 278 61 $1,461.00
28 397 87 $2,085.50
29 233 77 $1,431.50
30 210 120 $1,695.00
31 402 32 $1,663.00
32 152 203 $2,156.00
33 105 69 $919.50
34 285 42 $1,333.50
35 276 0 $966.00
36 115 177 $1,818.50
37 279 97 $1,752.50
38 311 59 $1,560.50
39 337 7 $1,235.50
40 156 66 $1,074.00
41 405 81 $2,065.50
42 0 50 $400.00
43 313 75 $1,695.50
44 528 0 $1,848.00
45 222 52 $1,193.00
46 233 0 $815.50
47 374 240 $3,229.00
48 84 159 $1,566.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Probability Models

Authors: Sheldon M Ross

5th Edition

1483276589, 9781483276588

More Books

Students also viewed these Mathematics questions