The forecasts generated by two forecasting methods and actual sales have been collected in the Microsoft Excel Online file attached. Use the Microsoft Excel Online file attached to develop forecast accuracy and answer the following questions.  1. What is the MAD, the MSE, the MAPE, the RSFE, and the tracking signal for each forecasting method? Do not round intermediate calculations. Round your answers to two decimal places. Use the minus sign to enter negative values, if any. 2. What can be concluded about the quality of the forecasts 2? Assume that the control limit for the tracking signal is ±3. The results indicate (bias or no bias) in the forecasts 2, and that the tracking signal (is not or is) within the control limits of ±3.

Q: Southern State Fatalities Western State Fatalities AL AZ AR 3 CA 3 FL 17 ID MT 1 GA KY NM 1 LA NV MS…

A: Given Let  Xs be the fatalities in southern stateXW be the fatalities in western stateXs be the…

Q: Consider the​ women's 100-yd dash​ (and the subsequent​ 100-m dash) in the Olympics since records…

A: Introduction: Associated variables: Two variables are associated or related if the value of one…

Q: (a) For these 25 students, as the time spent texting increases, the time spent exercising tends to…

A:

Q: In order to determine whether or not there is a significant difference between the hourly wages of…

A: It is required to find the p-value for the given hypothesis test.

Q: The engine displacement (in cubic inches) and the fuel efficiency (in miles per gallon) of seven…

A: Given the data of the engine displacement (in cubic inches) and the fuel efficiency(in miles per…

Q: Suppose we have the following data for the number of daily visitors to a website over a 7-day…

A: (a) To calculate a 3-day moving average, we take the average of each group of three consecutive…

Q: Rick is a school principal, and he is trying to decide if there is a relationship between conduct…

A: We plot number of infractions on x-axis and number of student present in the school on the y-axis.

Q: Mode of Learning of the Respondents Mode of Learning Frequency Percentage Asynchronous Learning 3…

A: As per our guidelines, we are allowed to answer first question only. Thanks Data : Here X =…

Q: b) Given the following data: Month Sales Month Sales July August September 38.0 October 35.0 January…

A: “Since you have posted multiple questions with multiple sub-parts, we will solve the first three…

Q: (c) Fine Teak Ltd has used two methods of forecasting in order to forecast the sales of its sofa…

A: Mean absolute deviation is the average deviation between the difference of observed and expected…

Q: Use the data given in the three scenarios below to produce scatter plots, determine the type of…

A: The plot is drawn between  the month and the mean peak gusts

Q: On May 3, 1999, 59 tornadoes hit a certain state in the largest ornado outbreak ever recorded for…

A: Data58436611761438120147123

Q: c. Identify all outliers using the boxplot. Write down the values and indicate which type they apply…

A: A boxplot is a graphical representation that describes the shape of the distribution and variability…

Q: Discuss why it is important to monitor forecast errors ?

A: Four reasons to track forecast accuracy:- 1.Improving your forecasting process requires the ability…

Q: Mrs. Pearce conducted a survey in her class on the ages of famous people. The table below shows the…

A: Firstly plot the points:

Q: The electric energy consumed each month by a manufacturingwarehouse is imagined to be linked to the…

A: According to the given information, the electric energy consumed each month by a manufacturing…

Q: Represent the data on a scatter plot. Choose an appropriate scale and label for each axis and…

A: Given, Year Enrollment in College( millions) 0 8.6 10 12.1 20 13.8 30 15.3 40 18.1…

Q: An insurance company wants to know if the average speed at which men drive cars is higher than that…

A: Confounding variable has a strong influence in causal relationship.

Q: RMSE ME MAD MPE MAPE % %

A: here we have to find RMSE,ME,MAD,MPE,MAPE  we use excel to find RMSE,ME,MAD,MPE,MAPE

Q: Things to do:  1. Create a Table of Expenses from the following data:  Cost of Expenses (in a…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: None

A: To address the question in the image, I'll perform the following steps: 1. Extract the commute times…

Q: e accompanying table represents the odometer mileage, in thousands of miles, of 30 unused cars…

A: Given:…

Q: Create a side-by-side boxplot for vitamin D level vs. NewAge and a side- by-side boxplot for vitamin…

A: Vitamin D is an important nutrient that is essential for healthy bones and teeth, as well as a…

Q: 5. Complete the following: Draw a scatter plot of the data below. b. Draw a trend line. Write its…

A:

Q: Fitting a straight line to a set of data yields the following prediction line. Complete (a) through…

A: a. The given regression line is, Ŷi = 8 + 4Xi.

Q: This question utilizes the BookPrices data set found in the resampledata package. This data set…

A: The data to be used in R is BookPricesThe sample data obtained from R is as followsIt is required to…

Q: In order to forecast enrollment for next fall, XYZ University of the CBA wishes to forecast…

A: The enrollment data of past 10 years os given. We need to calculate the slope, intercept, and linear…

Q: 3. Consider the following sets of data from Dataset II. For the dataset, determine what type of…

A: Carolyn collected data on rates of recycling participation over the last eight years to determine…

Q: Consider the women's 100-yd dash (and the subsequent 100-m dash) in the Olympics since records have…

A: Steam and leaf plot help us to compress the data in the compact form and also helps us in…

Q: The value of a certain car when it was brand new with 0 mileage was $17,000 but the value dropped to…

A: The given scatter plot is a linear and it's slope is negative. Given that, at zero miles the value…

Q: A graph that uses vertical bars to represent qualitative data is called a

A: A graph that uses vertical bars to represents qualitative data is called bar diagram. Thus, the…

Q: 38. Price of an app. Fifty people were asked how much they paid for the last smart phone app they…

A: Given data is: x f 1 18 2 17 3 9 4 3 5 2 6 0 7 1 Total 50   Probability of x…

Q: b) Given the following data: Month Sales Month Sales January February March 25.0 31.0 29.0 33.0 34.0…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: Draw a box plot for the following data: Median: 4.5 Lowest Value: 1 Greatest Value: 9 Lower…

A: Given that       Median = 4.5      Lowest value = 1    Greatest value = 9   Lower quartile = 2.5…

Q: please answer in text form and in proper format answer with must explanation , calculation for each…

A: The prompt appears to be related to calculating the number of neutrons and electrons in different…

Q: Your younger brother, a fourth form practical geography student wishes to test whether there could…

A: In this case, the student is willing to regress the number of visits by using the distance from the…

Q: A car company wants to know the monthly sales made in ($000), based on the brand of vehicle. The…

A: d)  xT=165000nT=27sT=9500 The confidence interval is 90%, so the significance Level α=0.1 The…