The data below are the monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. i. Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a=0.2. (Use naive to start the exponential smoothing process) ii. Compare the forecasts using MAD and decide which is best. iii. Using your method of choice, make a forecast for the month of July. Month        Sales Jan             45 Feb             30 March         40 April            50 May            55 June            47

Q: Create a 2-D line chart of Cash Sales for months 1-18. Add a trend line with a forward forecast of 3…

A: Given Information: Consider the given data: Months Cash Sales 1 2145600 2 2175200 3 2255200…

Q: Interpret the slope of the regression line in the context of the question:   For every additional…

A:

Q: Fit a trend equation from the data given below and hence find the sales for year 2016. year  2011…

A: The regression equation of given data set is given as follows :

Q: A marine biologist has been monitoring the salmon population in a local river. He records the…

A: Given Month salmon 1 18 5 56 6 70 10 106 18 215 20 240 28 452

Q: COMPLETE 6 STEP HYPOTHESIS A study was conducted to determine if there was a linear relationship…

A: Here, we want to study the effect of age on the rate of peak heart rate in a group of individuals.…

Q: The accompanying data are from a football league for one season. a. Construct a scatter diagram for…

A: The dependent variable is Points/Game.The independent variable is Yards/Game.This is Simple linear…

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: The scatter plot shows the theater revenue and rental revenue for each of 21 movies. Also shown is…

A: (a)Recall that in scatterplot, if the line is increasing from left to right, then the relationship…

Q: The table below shows the number of years since and the price of milk.

A: “Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: The accompanying scatterplot shows data on age, denoted A, of a sample of students and the number of…

A: A scatterplot is a graphical representation which shows the graphical representation b/w 2…

Q: The table below shows the number of state-registered automatic weapons and the murder rate for…

A: We have given data in the form of a table that contains, the number of state-registered automatic…

Q: Gio sells gelato and collected sales data for the past few days. Calculate the 3- period moving…

A: The question is about forecasting Given :   To find : 3-period moving average forecast for day 6

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: fx| A B C F G H J Is there a relationship between Quantity Sold (Output) and Price and Advertising…

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

Q: Our linear model for Saratoga homes uses the Size to estimate the Price: Price = -3.117 +94.454 Size…

A: See the attached solution.

Q: Determine the equation of the trend line for the data shown below on Canadian balance of payments…

A:

Q: Food trucks have become a common sight on American campuses. They serve scores of hungry students…

A: The time series analysis is the method to model data which is time dependent. The observation which…

Q: mex PLC has gathered following information on the sales of face mask from April 2020 to eptember…

A: Let months following April be denoted by 1, 2, 3 and so on. And

Q: By plotting the graph of the given data mention whether there is a positive trend, negative trend or…

A: The graph of the given data can be obtained using excel steps as follow: Enter the data into excel…

Q: 1. The demand and price of a product is given in the following table: Price (Tk.) Demand (kg) 23 35…

A: d). Enter the given data into excel as follows:

Q: Fit a trend line by the method of least square method to the following data: Year 1998 1999. 2000…

A:

Q: A pharmaceutical company would like to make an accurate forecast about vitamins sales in 2022.…

A: Given information: The data presents the values of the variable sales for the years 2012 to 2022.

Q: Which value in the exponential model represents something similar to the y-intercept of a linear…

A: As two questions are given , I will solve only one. If we consider the y-intercept in linear model,…

Q: The following table gives the average monthly exchange rate between the U.S. dollar and the euro for…

A: The given data is as follows: January1.289February…

Q: Month Price Jan 2020 $42.28 Mar 2020 $39.49 July 2020 $37.98 Aug 2020 $39.09 Sept 2020 $40.30 Nov…

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

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: The table below shows the number of state-registered automatic weapons and the murder rate for…

A: Given , x = thousands of automatic weapons.  y = murders per 100,000 residents.  Regression equation…

Q: Write down the properties of R2. If R2=53.7%, interpret your data. Distinguish between the…

A: Coefficient of Determination :                   It is denoted by R-squared (R2 ) . Coefficient of…

Q: of mistakes made (y). graph shows the scatterplot of the data and a fitted line.

A: We know that if the orientation of data points on the scatter plot is in upward direction, then…

Q: Ans. d. Use Excel to find the coefficient of determination r?. Ans. e. What % of the variation can…

A: We are given with the data from that we can calculate R2 i.e. Coefficient of determination  The…

Q: run a simple regression- dependent variable is Weeks, independent variable is Age.    B. run a…

A: A: dependent variable is Weeks Independent variable is Age.  Excel Procedure: Enter weeks and Age…

Q: Use the Women's Earnings scatterplot below to answer the questions. Women's Earnings as a Percentage…

A: From the scatterplot, the linear regression equation is y^=0.617x-1156.3. Estimate the women’s…

Q: 9. a. Obtain the linear trend equation for the following data on new checking accounts at Fair…

A:

Q: EEE C ICK the icon to view the data table. plete parts a through g. d) If you want to sell an…

A:

Q: Amex PLC has gathered following information on the sales of tace mask fPom Api September 2020. Month…

A: Let months following April be denoted by 1, 2, 3 and so on. And

Q: 9. a. Obtain the linear trend equation for the following data on new checking accounts at Fair…

A: PeriodNew accounts120022143211422852356232724882509253102671128112275132801428815310

Q: v. Calculate the intercept (rounded off to four decimals).

A: Here given b = slope of line = 1.0303 X bar = 5.5 Y bar = 6.8

Q: A bacteriologist charted the growth of a certain bacterium over a period of eight hours. The data…

A: Solution: Let X be the hour and Y be the number of cells. The given data is