Question

In: Statistics and Probability

I have the following data Week of Expenses Revenues Profit 6-Dec-04 103,084 122,533 19,449 13-Dec-04 99,584...

I have the following data

Week of Expenses Revenues Profit
6-Dec-04 103,084 122,533 19,449
13-Dec-04 99,584 131,036 31,452
20-Dec-04 94,936 137,813 42,877
27-Dec-04 100,757 114,495 13,738
3-Jan-05 102,736 120,579 17,843
10-Jan-05 94,866 182,122 87,256
17-Jan-05 96,158 137,983 41,825
24-Jan-05 97,013 104,668 7,655
31-Jan-05 97,796 117,807 20,011
7-Feb-05 106,315 157,735 51,420
14-Feb-05 92,307 145,685 53,378
21-Feb-05 89,923 129,758 39,835
28-Feb-05 100,546 130,642 30,096
7-Mar-05 99,270 85,895 (13,375)
14-Mar-05 98,632 125,994 27,362
21-Mar-05 100,273 113,194 12,921
28-Mar-05 100,006 127,209 27,203
4-Apr-05 105,531 114,713 9,182
11-Apr-05 92,774 145,468 52,694
18-Apr-05 103,169 151,959 48,790
25-Apr-05 105,794 68,623 (37,171)
2-May-05 98,534 126,485 27,951
9-May-05 97,474 97,000 (474)
16-May-05 102,492 121,350 18,858
23-May-05 105,295 137,074 31,779
30-May-05 99,640 152,589 52,949
6-Jun-05 101,201 153,171 51,970
13-Jun-05 99,726 136,244 36,518
20-Jun-05 96,206 101,012 4,806
27-Jun-05 100,878 156,135 55,257
4-Jul-05 99,439 125,567 26,128
11-Jul-05 95,537 154,901 59,364
18-Jul-05 105,354 128,439 23,085
25-Jul-05 89,897 116,745 26,848
1-Aug-05 91,257 168,639 77,382
8-Aug-05 104,675 148,706 44,031
15-Aug-05 93,216 141,687 48,471
22-Aug-05 102,284 141,879 39,595
29-Aug-05 103,959 106,889 2,930
5-Sep-05 97,823 169,328 71,505
12-Sep-05 97,765 126,747 28,982
19-Sep-05 108,032 154,728 46,696
26-Sep-05 101,433 162,576 61,143
3-Oct-05 96,548 138,661 42,113
10-Oct-05 93,295 158,689 65,394
17-Oct-05 100,227 135,165 34,938
24-Oct-05 97,876 112,240 14,364
31-Oct-05 102,985 118,904 15,919
7-Nov-05 100,099 141,778 41,679
14-Nov-05 102,245 161,104 58,859
21-Nov-05 102,353 140,226 37,873
28-Nov-05 105,811 133,108 27,297

He stated that profits from the last six months (26 weeks) before the fire are more indicative of future expected profits. He feels that only data from the last six months should be used to calculate future expected profits.To formally test Mr. James’s claim, test to see if there was a significant difference in mean weekly profits between the first 6 months of the year and the last 6 months.  Use a 0.05 significance level and assume equal variances.  Does this support Mr. James’s claim?

Solutions

Expert Solution



Related Solutions

How may I increase the net profit by $350,000 while factoring in both revenues and expenses?
How may I increase the net profit by $350,000 while factoring in both revenues and expenses?
Chapter 13 The following financial statement data is available for the Scottsdale Company for Dec. 31,...
Chapter 13 The following financial statement data is available for the Scottsdale Company for Dec. 31, 2019. (30 pts) Comparative Balance Sheet Data                                                                  2019                  2018 Cash                                                    $ 39,835         $    4,000 Accounts Receivable                               17,500             12,950 Dividends Receivable                               1,000                      0 Inventory                                                42,000             35,000 Prepaid rent                                               3,000             12,000 Prepaid insurance                                      2,100                  900 Office supplies                                          1,000                  750 Long-term investments                           20,000             30,000 Land                                                    125,000         175,000 Building                                              350,000         350,000...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 a. Use a smoothing constant of a = 0.4 to compute the MSE (to 2 decimals). (___) 2.Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 17 12 17 15 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if...
Consider the following time series data. Week 1 2 3 4 5 6 Value 20 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 20 13 15 10 18 14 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. (a) Mean absolute error If required, round your answer to one decimal place. (b) Mean squared error If required, round your answer to one decimal place. (c) Mean absolute percentage error If required, round your intermediate calculations and final...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 17 11 17 15 Calculate the measures of forecast error using the naive (most recent value) method and the average of historical data (to 2 decimals). Naive method Historical data Mean absolute error Mean squared error Mean absolute percentage error Top of Form Consider the following time series data. Month 1     2 3 4 5 6 7 Value 23 14 19 10 18...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 17 12 17 15 a. develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary). b. use = 0.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 7 (to 2 decimals). c. use a smoothing constant of =0.4 to compute the MSE...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 17 12 17 15 a. Which of the following is a correct time series plot for this data? What type of pattern exists in the data? b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week (to 2 decimals if necessary). MSE The forecast for week c. Use to compute the exponential smoothing forecasts for the...
Following are selected transactions of Danica Company for 2016. Dec. 13 Accepted a $19,000, 45-day, 6%...
Following are selected transactions of Danica Company for 2016. Dec. 13 Accepted a $19,000, 45-day, 6% note dated December 13 in granting Miranda Lee a time extension on her past-due account receivable. 31 Prepared an adjusting entry to record the accrued interest on the Lee note. Complete the table to calculate the interest amounts at December 31st and use the calculated value to prepare your journal entries. (Do not round your intermediate calculations. Use 360 days a year.) Complete the...
In C#, I have 6 teaching positions. I have to keep my salary expenses below $250,000...
In C#, I have 6 teaching positions. I have to keep my salary expenses below $250,000 and each position carries insurance and tax costs equal to 25% of their salary. Create an application that allows me to enter the Years of Experience for 6 teacher positions. Based on those years of experience, look up the minimum salary, total the salaries for all 6 positions. Calculate the 25% tax and insurance expense based on the salaries, and display the total of...
The Kelsh Company has two divisions--North and South. The divisions have the following revenues and expenses:...
The Kelsh Company has two divisions--North and South. The divisions have the following revenues and expenses: North South Sales $1,060,000     $976,000    Variable Expenses $522,000     $348,000    Traceable Fixed Expenses $356,000     $290,000    Allocated Common Corporate Expenses $256,000     $206,000    Net Operating Income (Loss) $(74,000)    $132,000    Management at Kelsh is pondering the elimination of North Division. If North Division were eliminated, its traceable fixed expenses could be avoided. The total common corporate expenses would be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT