quality one consulting currently has three offices in southern california. the following table shows each offices account numbers and profits. quality one is planning to open a new office in north ridge. please use linear regression method o forecast the profits that would be generated from north ridge office.
| office | pasadena | long beach | beverly hills | northridge |
| # of office accounts (x) | 7 | 4 | 7 | 4 |
| profits (7) in $ millions | 10 | 3 | 8 | ??? |
1. what is the parameter value of b in linear regression function?
2. assume the parameter value of b is -2. use the assumed value b= -2 to calculate the parameter value of a in the linear regression function.
3. assume the parameter values to forecast the profits from north ridge office.
quality one consulting currently has three offices in southern california. the following table shows each offices...
Maximum Accounting firm currently has two offices in Southern California. The following table shows each office’s account numbers and profits. The firm is planning to open a new office in Northridge. The expected number of accounts for the new Northridge office is 3. Please use linear regression method to forecast the profits that would be generated from the new Northridge office. Office Pasadena Long Beach Northridge # of accounts (x) 8 10 3 Profit (y), in millions $ 14 20...
Regression Analysis Problem #1 The following table shows the sales (in $100,000) of a certain product as a function of the past 10 months and the level of advertisement (in S1,000) for the corresponding months Sales 100 110 107 110 118 120 117122 120 125 Month 2 4 5 7 8 10 Advertisement 1.5 2.1 2,6 2.8 3.5 3.7 3.6 3.4 3.4 2.9 Part A: Considering a simple linear regression of sales vs, time (months), perform the following analysis manually,...
Refer to Table 1. Write the Excel formula for each cell marked with “?” in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with “Copy & paste”. Label each formula clearly with cell reference position. In 2020, BS Bank employs 800 employees in its call centres in the United States...