TABLE LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH Census Tract Population Latitude Longitude Population × Latitude Population × Longitude 15 2,711 42.134 -80.041 114,225.27 -216,991.15 16 4,161 42.129 -80.023 175,298.77 -332,975.70 17 2,988 42.122 -80.055 125,860.54 -239,204.34 25 2,512 42.112 -80.066 105,785.34 -201,125.79 26 4,342 42.117 -80.052 182,872.01 -347,585.78 27 6,687 42.116 -80.023 281,629.69 -535,113.80 28 6,789 42.107 -80.051 285,864.42 -543,466.24 Total 30,190 1,271,536.04 -2,416,462.80

TABLE LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH Census Tract Population Latitude Longitude Population × Latitude Population × Longitude 15 2,711 42.134 -80.041 114,225.27 -216,991.15 16 4,161 42.129 -80.023 175,298.77 -332,975.70 17 2,988 42.122 -80.055 125,860.54 -239,204.34 25 2,512 42.112 -80.066 105,785.34 -201,125.79 26 4,342 42.117 -80.052 182,872.01 -347,585.78 27 6,687 42.116 -80.023 281,629.69 -535,113.80 28 6,789 42.107 -80.051 285,864.42 -543,466.24 Total 30,190 1,271,536.04 -2,416,462.80

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter6: Target Markets: Segmentation And Evaluation

Section: Chapter Questions

Problem 17DRQ: Under what conditions might a firm use multiple forecasting methods?

See similar textbooks

Similar questions

Given the data below, what is the simple linear regression model that can be used to predict sales in future weeks? Week 1 2 3 4 5 Sales 150 157 162 166 177
Consider the following quarterly demand level for electricity (in 1000 megawatts) in Mankweng from 2018 to 2022: 2018 2019 2020 2021 2022 Jan – March 21 35 49 60 10 - Apr – June 42 54 55 64 05 July – Sept Oct – Dec 60 91 95 99 12 14 74 80 1. Find the least squares trend line for electricity demand using Exx=0 method. 2. Find the seasonal index for each quarter. 3. Find adjusted seasonal index. 4. Find the De-seasonalized values for Quarter 1, 2,3 and 4 for the year 2023.
Seasonal relatives. Obtain estimates of quarter relatives for these data using the centered moving average method: YEAR 1 2 3 4Quarter: 1 2 3 4 1 2 3 4 1 2 3 4 1Demand: 14 18 35 46 28 36 60 71 45 54 84 88 58
Use a graphing calculator to create a scatter plot and find the line of best fit and the correlation coefficient for the following data. Round to the nearest hundredth. X 5 10 15 20 25 30 35 y 1,800 1,750 1,590 1,490 1,400 1,275 1,010
For the E-Commerce Retail Sales (Million$) data given in the table below, provide estimates from the 1st Quarter (Q1) of 2016 to the 3rd Quarter (Q3) of 2017 by using two models: 1) Single Exponential Smoothing with α=0.3 2) Moving Average with k=2. Calculate MAPE for each model. Quarter Year Actual Q1 2016 86802 Q2 2016 92004 Q3 2016 93795 Q4 2016 124651 Q1 2017 99491 Q2 2017 106590 Q3 2017 108291 Compare two models above (Single Exponential Smoothing and Moving Average) based on their accuracies. Which forecasting method appears to be better? Using the model you choose, provide forecast for the 4th Quarter (Q4) of 2017. Assuming that this model is overestimating, find the actual value of the Q4 of 2017 based on MAPE value. Some residual graphs from the first forecast model (including wider range of E-Commerce Retail Sales data) are given below. What do these graphs tell about the model? Explain each graph.
The quarterly sales in millions for AutoKo Corporation, an automobile dealership company over the past three years are given in the following table. Compute for the seasonal factor of Quarter 3. YEAR 1 YEAR 2 YEAR 3 Quarter 1 1710 1820 1830 Quarter 2 960 910 1090 Quarter 3 2720 2840 2900 Quarter 4 2430 2200 2590
Develop Linear Regression Model. Forecast sales for 8, 14 and 17 years of education. Sales(1000s) Years of Education 24 10 18 9 20 11 22 6 26 13 23 16 21 18
Make provision for analysing time series using five most popular statistical approaches?
A study of 1,000 adult Canadians was undertaken in an effort to obtain information about Canadian shopping habits. One of the results of this survey was that 23% often buy items that are not on their shopping list but catch their eye. Use this study result to estimate with an 80% level of confidence the population proportion of Canadian shoppers who buy items that are not on their shopping list but catch their eye. Appendix A Statistical Tables (Round the answers to 3 decimal places.)enter the lower value of the interval ≤ p ≤ enter the upper value of the interval
15. The sales of a company for the years 2011 to 2017 are given below : 2013 65 2016 132 2017 275 2015 2012 47 2014 92 Year Sales (in million) Find trend values by using the equation Ye = a b and estimate the value for 2020. 2011 32 190 bong
Obtain estimates of daily relatives for the number of customers at a restaurant for the evening meal, given the following data. Day 1 23456789GH23H 10 11 12 13 14 Number Served 87 82 83 99 145 142 48 80 79 87 92 134 138 41 Day 15 PEAREANNN8 16 17 18 19 20 21 22 23 24 25 26 27 28 Number Served 82 83 88 99 132 148 46 82 83 81 90 133 139 44 Click here for the Excel Data File: a. Use the centered moving average method. (Hint: Use a seven-day moving average.) (Round your intermediate calculations and final answers to 4 decimal places.)
Quarterly sales of a local department store over a 4-year period are given below: Quarters 2016 Q1 Sales (in millions) 500 Quarters 2018 Q1 Sales (in millions) 560 2016 Q2 490 580 2018 Q2 2018 Q3 2018 Q4 2019 Q1 2019 Q2 2016 Q3 570 630 2016 Q4 2017 Q1 2017 Q2 750 720 480 540 500 590 2017 Q3 580 2019 Q3 620 2017 Q4 740 2019 Q4 790 The data shows sign of seasonality. By computing seasonal indices for each quarter, forecast the sales for each quarter in year 2020, given that the estimated sales in 2020 is