Please use google looker studio PART 2: NEW USER ACQUISITION (FIRST USER PRIMARY CHANNEL GROUP)DATANew Users from Direct:Engagement rate from Email:Revenue from Paid Search:New users from Referral:Key events from Org. Search:Revenue from Email:QUESTIONWhich channel had the most engaged new user traffic (you choose the metric you believe is thebest reflection of engagement-specify the metric you used)? This assignment asks you to find many datapoints from Analytics reports. Unless specifiedotherwise, find the statistic for December of last year. (If it is currently December 2024, useDecember 1, 2023 to December 31, 2023.)

We looked at variables like New Users, Engagement Rate, Key Events, and Revenue to find the best…

Answered: PART 2: NEW USER ACQUISITION (FIRST…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 20P: The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year...

See similar textbooks

Similar questions

The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?
3
The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6. Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09 Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75
To better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table shows the value of food and beverage sales ($1000s) for the first three years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third Year January 242 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 160 July 145 157 166 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 206 230 235 Managerial Report Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: A time series plot. Comment on the underlying pattern in the time series.…
A company that supplies gasoline to a city has recorded the weeklyusage (tons/week) for the past 3 years. The file BA3653GasolineRecord.xlsxcontains this record.(a) Propose a method for predicting the demand for gasoline. Use thatmethod to forecast demand for next year (weeks 157 to 208).(b) Improve your prediction in part (a) by including a statement about demand variability. (Hint: Look at or the range of the data.) week demand (tons) 1 1174.5 2 1316.2 3 1197 4 1127.3 5 1193.1 6 1260.7 7 1378.2 8 1273.7 9 1366.4 10 1113 11 1177.7 12 1056 13 1291.2 14 1269.1 15 1289.6 16 1181 17 1249 18 1212 19 1286.2 20 1204.8 21 1266.2 22 1332.4 23 1236.3 24 1266.1 25 1415.3 26 1100.1 27 1208.1 28 1505.1 29 1282.7 30 1190.5 31 1152.8 32 1089.7 33 1404.7 34 1308.6 35 1255.4 36 1106.7 37 1484.6 38 1317.4 39 1294.7 40 1154 41 1449.9 42 1174.9 43 1466.9 44 1282.4 45 1228 46 1174 47 1196.2 48 1443.8 49…
PLEASE SOLVE IT COMPLETELY AND ACCURATELY. DON'T COPY FROM ANYWHERE
Suppose that you work at a local food manufacturer and are given the task of investigating your company's seasonal sales patterns over the past 10 years (2011 to 2020). After adjusting your sales values for inflation, you calculate the following seasonal sales averages (in millions): Spring: 39 Summer: 46 Fall: 32 Winter: 23 Use this information to seasonally adjust your 2021 Winter sales total of 29 million. Round your answer to two decimal points and omit any units (1.23 NOT $1.23 million).
A business conducted a linear regression to estimate its demand function and obtain the following demand function Q = 200 - 1.5P + 0.55A - 2.8Py + 0.05Inc, where P is price and A is advertising. When P = $21. A = $30 and Quantity = 160, find the profit-maximizing advertising-to-sales ratio (hint: first find the price and advertising elasticities). Type as either a decimal out two spaces, like 0.10 OR as a percentage like 10%. %3! %3! Question 17 During recessions, people's reservation price (aka reserve price) searching. which results in O drops; less O rises; more drops; more O rises; less
The manager wants to forecast the month 6's sales using the following historical data: Months Month 1 Month 2 Month 3 Month 4 Month 5 Sales 20 25 32 35 38 Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 5.
Cost Estimation; High-Low and Regression Methods The Mac Davis Company specializesin the purchase, renovation, and resale of older homes. Mac employs several carpenters and paintersto do the work for him. It is essential for him to have accurate cost estimates so he can determinetotal renovation costs before he purchases a piece of property. If estimated renovation costs plus thepurchase price of a house are higher than the house’s estimated resale value, it is not a worthwhileinvestment.Mac has been using the home’s interior square feet for his exterior paint cost estimations. Recentlyhe decided to include the number of external openings—the total number of doors and windows ina house—as a cost driver. Their cost is significant because they require time-consuming preparatorywork and careful brushwork. The rest of the house usually is painted either by rollers or spray guns,which are relatively efficient ways to apply paint to a large area. Mac has kept careful records of theseexterior…
Do you agree that all students in tertiary level (college, university, etc.) need to take at least one statistics subject in their program? Explain why.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS