Spring 23 Assignment 6 Addl Exs

QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.

Question 3 An organization uses a business intelligence system to predict products that tend to be purchased together. This is an example of. O A) Regression Analysis B) Cluster Analysis C) REM Analysis D) Market Basket Analysis

QUESTION 4  The following table shows the weights and prices of some whole rotisserie chickens at Price Mart. Make a scatterplot with weight on the x-axis and cost on the y-axis. Include the regression line on your scatter    Find the numerical value for the correlation between weight and Explain what the sign of the correlation  What is the equation of the best-fit straight line, using weight as the predictor (x) and cost as the response (y).  What does the slope of the regression line tell us?  Find and interpret the coefficient of determination using the original    Weight (lb.) Price 2.8 $3.92 3.7 $4.70 2.9 $4.41 4.2 $5.38 5.3 $6.84 4.7 $5.99

Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques

Regression line. A large midwestern retailer has developed a graph that summarizes the effect of  advertising expenditures on sales volume. Using the graph, determine an equation of the form y = a + bx that describes this relationship.

Please do not give solution in image format thanku

q10-  What is the best description of Granger-causality? Select one: a.   the ability of lags of one variable to contribute to the forecast of another variable   b. the ability of a variable to predict its own future c. the ability of the one variable to explain it own past d. None of the above Clear my choice

A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage Industry and collects monthly data for 25 firms. He estimates the model Sales-o Advertising. The following ANOVA table shows a portion of the regression results. Regression Residual df 1 23 55 78.53 504.02 MS 78.53 21.91 T 3.58

V. Let's Explore / Let's Create 1. Discuss the other types of forecasting methods that financial analysts use to predict future revenues. 2. Are there any several other factors that may need to be considered that affects the sales forecast? RUBRIC Criteria Poor (3 Points) Fair (7 Points) Fair Good (10 Points) Good Deer

Month Actual Sales Naive Forecast- Absolute Value of (# of Product X) Sales Errors (# of Product X) Jan/19 Feb/19 Mar/19 Apr/19 May/19 Jun/19 Jul/19 Aug/19 Sep/19 Oct/19 Nov/19 Dec/19 Jan/20 1,860 2,033 3,556 4,211 6,250 7,990 10,250 9,850 9,980 9,990 7,895 5,353 - Explain the calculation method for the Naive Forecast model. the faln

Divvy Bikes 2021 summer ridership has increased 30% from the ridership levels in 2020.  Divvy's management attributes this to 2020 having fewer work places and recreation venues were open than in 2021.   This is an example of which type of data analytics?   Question 6 options:   a)  Descriptive   b)  Diagnostic   c)  Predictive   d)  Prescriptive

QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series:  Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6      Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below:    Coefficients Intercept 2,506 Time 71.3  If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)

q1(a)Imagine that you need to introduce a new gadget such as the Apple Watch. Determine which forecasting method is appropriate for projecting the future demand of such this gadget. b)ARIMA is mostly used to forecast future values using historical time series data, as we all know. Its primary use is in short-term forecasting with at least 38-40 historical data points and a small number of outliers. If we don't have at least 38 data points, we should consider using another strategy.

Please do not give solution in image format thanku

Trail Questions National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales ('000 units) Feb. 19 Mar. 18 Apr 15 May 20 Jun. 18 Jul. 22 Aug. 20 Forecast September sales volume using each of the following: (1) A linear trend equation. (2) A five-month moving average (3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 19('000) (4) A weighted average using 0.60 for the most recent month, 0.30 for the next most recent, and 0.10 for the next.

Q5) Monthly sales for a six month period are as follows:  Month SalesJan 18,000Feb 22,000Mar 16,000Apr 18,000May 20,000June 24,000 Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April;(3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000

Question Using a suitable moving average method, find the trend values.

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Question 1 ) The monthiy sales Of yamizí Battery company are asfollows:- Month Jales 2000 2100 1500 1400 1300 Calcuiate fore cost sales for June using each of the fo llowing method: - i) Naive Method 1M 3 Month Simple moving averoger Ti) Exponentral smoothing using an a =0:3 cand may forecast of 1600 units.

4. What is the difference between trend and seasonality in time series data? 5. Here are the errors associated with a particular forecast over the past 5 months, in chronological order: 5, 10, -15, 0, 8. In which month was the forecast perfectly accurate? In which month was the forecast the least accurate? In which month or months was the forecast too high? (Noteshaper Ramp Up # 23) 6. Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time series data recently: Time Period Code Student Appointments Jan 6 - 10 95 Jan 13 - 17 80 Jan 20 - 24 65 Jan 27 – 31 4 50 a) What is the naïve forecast for the number of student appointments for Time Period 5 (Feb 3– 7)? b) What is the 2 week moving average for Time Period 5? c) What is the 3 week moving average for Time Period 5? d) What is the forecast for Time Period 5 using exponential smoothing with alpha =…

Question A reputable FMCG company is holding its Annual Sales Conference on January 30th 2021 for its New Year sales plan. The company is interested in launching new product beside its existing product lines. The new product will be novel in the history of the company.  explain what FMCG company seeks for and following for above mentioned firm, with reason/limitations specified for the FMCG company. Discuss the techniques of forecasting that will be used by the company for its existing and new products. Explain specific type and reason for using those techniques. Also identify the limitations of these techniques. Use word/Excel