Suppose you are given the following data. You have run a three month moving average and found the forecasts, difference, and difference squared between the demand and forecasts. Note, the forecasts, difference, and difference squared have been rounded to two decimal places in the table. Month June 1 July 2 August 3 September 4 October 5 November 6 December 7 8 9 10 11 12 January February March April May O93.44 353.87 Time Determine the MSE (mean square error). 39.32 29.49 Actual Demand 93 96 96 83 94 94 87 97 86 93 89 99 Forecast 95.00 91.67 91.00 90.33 91.67 92.67 90.00 92.00 89.33 Difference Difference Squared -12.00 2.33 3.00 -3.33 5.33 -6.67 3.00 -3.00 9.67 144.00 5.44 9.00 11.11 28.44 44.44 9.00 9.00 93.44

Q: Using the 6 weeks of data below, forecast sales for the seventh week using a 4-week weighted moving…

A: Given that: Week Sales 1 281 2 292 3 276 4 289 5 302 6 314

Q: Table 1: Which set of data would best be modeled by an exponential function? I Y1 2 3.5 Y1 A X. Y1 -…

A: A general Exponential function is given by                    f(x) = ax           where a>0

Q: Using the 4 weeks of data below, forecast sales for the fift average. Week 2 3 4 O 12 O 16 Sales 22…

A: Week           sales1.                  22 2.                  183.                   144.…

Q: Answer parts (a) through (c). 2000 2010 2020 2030 2040 2050 (millions) 275.8 C 307.9 326.6 355.3…

A: Given: Year Population (millions) 2000 275.8 2010 307.9 2020 326.6 2030 355.3 2040…

Q: Calculate correlation co-efficient for the following data on supply and demand. Supply 400 200 700…

A: From the provided information, Supply (x) Demand (y) 400 50 200 60 700 20…

Q: The figure below shows the relationship between the price of a cellphone (in 100 TL) and the sales…

A: Given :

Q: Find correlation coefficient between the income and expenditure of a wage earner. Month: June July…

A:

Q: Ohara Manufacturing has decided to use an R-Chart to monitor the changes in the variability of their…

A: Ohara manufacturer has decided to R-chart.Given the value of the sample range.Want to calculate the…

Q: What is the independent variable in the graph? 100 90 80 70 60 50 40 30.- 20 10 4. 10 12 Time spent…

A: Graph is given between time spent studying and exam score

Q: Which of the following is an example of qualitative data that can inform data-driven decision…

A: A data consists of the collection of information in the form of a table which can be used for…

Q: ow, we see a snippet of a dataset that consists of 128 observations and 15 variables. We o models…

A: Given: The R output is as below

Q: Calculate the best (most complex/sophisticated/stable) measure of central tendency allowed for the…

A: Given,the data is - 3, 9, 9, 4, 2, 7, 1.and the variable is the favorite month.The numbers indicate…

Q: in the table. Episode # 1 2 3 4 8 7.2 8.2 7.9 8 7.7 9 7.5 Use a graphing calculator to find a line…

A:

Q: Consider the following data: Answer Month Jan-12 Feb-12 Mar-12 Profit ($) 6,500 6,253. 5,514 5,357…

A: MSE:- Mean square error, it is the average of absolute error and its formula is given by,MAD:-Mean…

Q: The scatter plot shows the time spent watching TV and the time spent doing homework by each of 24…

A: The drop down options in the question are not visible, so we will write the most appropriate…

Q: A merchant's sale (*00s tons) of ordinary coal over a period were as shown below: Quarters Years I…

A: Given,     Quarters     Years 1 2 3 4 2011 118 87 47 83 2012 94 73 41 68 2013 73 61 36 56

Q: Step 4 The following table summarizes the given data and the forecast values. There will not be a…

A: Step 1: The table of actual values, forecast values, forecast error and squared forecast errors are…

Q: The table below shows data from a study relating a man's age to the average number of miles he can…

A: We have given data study relating a man's age  to the average number of miles he can cover on foot…

Q: Unwed births The National Center for Health Statisticsreported the data below, showing the…

A: The least square regression equation is obtained using EXCEL: Select Data > Data analysis >…

Q: Consider the following demand levels for electricity (in Megawatts) for Rundu from 1988 to 1991.…

A: Given is a timeseries data for demand levels for electricity (in Megawatts) for Rundu from 1988 to…

Q: At Center Hospital there is some concern about the high turnover of nurses. A survey was done to…

A:

Q: Consider the following from an estate agent’s business nationally:   Month Houses Sold Jan 380…

A: The moving average are used to estimate the average changes that happen over a period of time. There…

Q: Bob is a photographer who sells prints on consignment. Each week during the summer, Bob checks the…

A: Week Sold 1 17 2 10 3 9 4 16 5 18 6 14 7 9 8 8

Q: using below, forecast sales for the fifth week using a 3-week weighte average. (round to nearest…

A: We are asked to find the forecast sale

Q: An analyst must decide between two different forecasting techniques for weekly sales of roller…

A: The data shows the weekly sales of roller blades.

Q: Below, we see a snippet of a dataset that consists of 128 observations and 15 variables. We present…

A: Yes model (3) is better than model (2).  As R2 for model (3) is 0.880 which is greater than R2 or…

Q: The scatter plot shows the time spent texting and the time spent exercising by each of 24 students…

A: Given:

Q: The U.S. Department of Health & Human Services (HHS) is a department of the U.S. federal government…

A: Given: The U.S department includes the Health & Human Services (HHS) based on the U.S. federal…

Q: estimate an appropriate measure of dispersion for the following data : Income (Rs.) No. of Persons…

A: We want to find the dispersion  Standard deviations is the best way to find the dispersion

Q: You are given the following quarterly sales information for ASTRA Company over the last 3 years.…

A: 1. Centered moving average To compute the central moving average, take the average to two…

Q: A study using body mass index (EMI)-an index af obesity-as a function of income (S thousands)…

A: Solution: Let x= Income  and  y = BMI  x y x2 y2 xy 15 31.1 225 967.21 466.5 20.5 29.4…

Q: 11 387 12 645 14528 20 122 22 122 28 166 29861 54304 44 189 42 651 46678 50 169 7904 10 326 7616 2.9…

A: Scatterplot

Q: The data below represent a random sample of 9 scores on a statistics quiz. (The maximum possible…

A: From the provided information, Sample size (n) = 9 Population standard deviation (σ) = 2.2…

Q: Below, we see a snippet of a dataset that consists of 128 observations and 15 variables. We present…

A: Here independent variables are  (i). Hip (ii). Forearm (iii). Wrist.  So there are 3 possible linear…

Q: The following data contain the quantity (millions pounds) of U.S. domestic fish caught annually over…

A: forecasting

Q: Use the following sales data: Week           Sales  1                     30 2…

A: a) We know that, in naive method we can calculate forecast value as, We get result as,  Using…

Q: Try to fit any two moving averages models to the following data and discuss its performance. YEAR…

A: Moving average:  It is a technique to get an overall idea of the trends in a data set; it is an…

Q: Table 3.2 Exports, Imports and Balance of Trade of India, 1993-94 to 1999-2000 (Rs '000 crore)…

A:

Q: A company has the following monthly sales for the past year.  Plot the data points on a line graph…

A: Given data,

Q: If you want to use the build-down method to test a model using age (in number of years) and sex…

A: The general conditions for the regress is given below: The samples are randomly selected from the…