Use Excel or Google Sheets to find the requested measures of central tendency for the following data set. 20.3 26.3 33.8 39.9 41.9 45.4 50.7 58.8 41 38.4 50.3 34.1 48 34.1 44.9 48.3 23.6 29.3 33 36.5 28.8 44.4 39.4 45.4 53.2 47 54 34.1 50.3 42.9 44 39.4 39.2 36.3 31 32 48.3 32.7 39.4 34.1 48 43.1 43.7 40.2 43.1 39.2 55 38.4 43.1 55 41.2 46.7 47.6 51.8 42.2 46.5 41.6 44.4 43.3 28.8 34.6 39 29.3 43.7 38 56.4 21.4 46.5 34.9 36.5 32.7 mean = Round to 2 places. median = Round to 2 places.

Use Excel or Google Sheets to find the requested measures of central tendency for the following data set. 20.3 26.3 33.8 39.9 41.9 45.4 50.7 58.8 41 38.4 50.3 34.1 48 34.1 44.9 48.3 23.6 29.3 33 36.5 28.8 44.4 39.4 45.4 53.2 47 54 34.1 50.3 42.9 44 39.4 39.2 36.3 31 32 48.3 32.7 39.4 34.1 48 43.1 43.7 40.2 43.1 39.2 55 38.4 43.1 55 41.2 46.7 47.6 51.8 42.2 46.5 41.6 44.4 43.3 28.8 34.6 39 29.3 43.7 38 56.4 21.4 46.5 34.9 36.5 32.7 mean = Round to 2 places. median = Round to 2 places.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter5: Business And Economic Forecasting

Section: Chapter Questions

Problem 1.6CE: Estimate the double-log (log linear) time trend model for log cruise ship arrivals against log time....

See similar textbooks

Similar questions

In attempting to formulate a model of the passenger arrival data on cruise ships over time would a nonlinear (perhaps a multiplicative exponential) model be preferable to a linear model of cruise ship arrivals against time? What about in the case of the passenger arrivals by ferry against time?
Suppose, as an economist, you are asked to analyze an issue unlike anything you have ever done before. Also, suppose you do not have a specific model for analyzing that issue. What should you do? Hint: What would a carpenter do in a similar situation?
Why is it unfair or meaningless to criticize a theory as unrealistic?
Furniture Forecasting Futura Furniture Products manufactures upscale office furniture for the Office of the Future. The sales division comprises regionally based sales offices made up of sales representatives and regional managers. Sales representativeswho report to the regional managersconduct direct sales efforts with customers in their regions. As part of the sales process, representatives gather information about likely future orders and convey that information back to the regional managers. Regional managers use that information to create sales forecasts, which are then used as the basis for manufacturing schedules. Sales representatives and regional managers are both compensated on a salary plus commission (percentage of revenue as pricing is centrally controlled). However, a regional managers commission is adjusted based on regional sales that exceed the forecasted budget. Corporate managers are concerned with one of Futuras key products, the DeskPod. They worry that DeskPod forecasts are inaccurate, causing extreme havoc in the manufacturing process. How are the forecasts likely to be inaccurate? What do you think is driving this inaccuracy? How might this problem be solved?
Plot the logarithm of arrivals for each transportation mode against time, all on the same graph. Which now appears to be growing the fastest?
Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: Y t=8.25+0.125t2.75D1t+3.50D3t where Y t=predictedsales(million)inquartert 8.25=quarterlysales(million)whent=0 t=timeperiod(quarter)wherethefourthquarterof2002=0,firstquarterof2003=1,secondquarterof2003=2,... D1t={1forfirst-quarterobservations0otherwiseD2t={1forsecond-quarterobservations0otherwiseD3t={1forthird-quarterobservations0otherwise Forecast Savings-Marts sales of patio and lawn furniture for each quarter of 2010.
Bell Greenhouses has estimated its monthly demand for potting soil to be the following: N=400+4X where N=monthlydemandforbagsofpottingsoil X=timeperiodsinmonths(March2006=0) Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: Forecast Bell Greenhouses demand for potting soil in March, June, August, and December 2007. If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast.
Metropolitan Hospital has estimated its average monthly bed needs as N=1,000+9X where X=timeperiod(months);January2002=0 N=monthlybedneeds Assume that no new hospital additions are expected in the area in the foreseeable future. The following monthly seasonal adjustment factors have been estimated, using data from the past five years: Forecast Metropolitans bed demand for January, April, July, November, and December 2007. If the following actual and forecast values for June bed demands have been recorded, what seasonal adjustment factor would you recommend be used in making future June forecasts?
The economic analysis division of Mapco Enterprises has estimated the demand function for its line of weed trimmers as QD=18,000+0.4N350PM+90Ps where N=numberofnewhomescompletedintheprimarymarketarea PM=priceoftheMapcotrimmerPS=priceofitscompetitorsSurefiretrimmer In 2010, 15,000 new homes are expected to be completed in the primary market area. Mapco plans to charge $50 for its trimmer. The Surefire trimmer is expected to sell for $55. What sales are forecasted for 2010 under these conditions? If its competitor cuts the price of the Surefire trimmer to $50, what effect will this have on Mapcos sales? What effect would a 30 percent reduction in the number of new homes completed have on Mapcos sales (ignore the impact of the price cut of the Surefire trimmer)?