Chapter 12, Problem 12.6AC

Compare the primary types of forecasting methods used to determine demand.

Use the Financial database from “Excel Databases.xls” on Blackboard.  Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company.  Use Excel to develop the multiple linear regression model.  Assume a 5% level of significance.   Which independent variable is the strongest predictor of the average P/E ratio of a company?     A. Total Revenues B. Average Yield C. Earnings Per Share D.Return on Equity E. Total Assets F.Dividends Per Share   Company Type Total Revenues Total Assets Return on Equity Earnings per Share Average Yield Dividends per Share Average P/E Ratio AFLAC 6 7251 29454 17.1 2.08 0.9 0.22 11.5 Albertson's 4 14690 5219 21.4 2.08 1.6 0.63 19 Allstate 6 20106 80918 20.1 3.56 1 0.36 10.6 Amerada Hess 7 8340 7935 0.2 0.08 1.1 0.6 698.3 American General 6 3362 80620 7.1 2.19 3 1.4 21.2 American Stores 4 19139 8536 12.2 1.01 1.4 0.34 23.5 Amoco 7 36287…

Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend ofmemberships in order to project future needs. What is the nature of the relationship between advertising expenditure and membership?   Forecast 2024 membership using an alternative method, clearly explaining the limitations of your selected method.        What are the limitations of the method used in (iii)?

How will marketers change their social media use in the near future? A survey by Social Media Examiner reported that 77% of B2B marketers (marketers that focus primarily on attracting businesses) plan to increase their use of LinkedIn, as compared to 54% of B2C marketers (marketers that primarily target consumers). The survey was based on 1,184 B2B marketers and 1,703 B2C marketers. The following table summarizes the results:   Give an example of a simple Give an example of a joint What is the complement of a marketer who plans to increase use of LinkedIn? Why is a marketer who plans to increase use of LinkedIn and is a B2C marketer a joint event?

Use the Financial database from “Excel Databases.xls” on Blackboard.  Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company.  Use Excel to perform a forward selection regression analysis.  Assume a 5% level of significance.  Which independent variables are in the final model?   Select all that apply.   Company Type Total Revenues Total Assets Return on Equity Earnings per Share Average Yield Dividends per Share Average P/E Ratio AFLAC 6 7251 29454 17.1 2.08 0.9 0.22 11.5 Albertson's 4 14690 5219 21.4 2.08 1.6 0.63 19 Allstate 6 20106 80918 20.1 3.56 1 0.36 10.6 Amerada Hess 7 8340 7935 0.2 0.08 1.1 0.6 698.3 American General 6 3362 80620 7.1 2.19 3 1.4 21.2 American Stores 4 19139 8536 12.2 1.01 1.4 0.34 23.5 Amoco 7 36287 32489 16.7 2.76 3.1 1.4 16.1 Arco Chemical 2 3995 4116 6.2 1.14 6.1 2.8 40.4 Ashland 7 14319 7777 9.5 3.8 2.3 1.1 12.4 Atlantic Richfield 7…

It has been suggested that sales for the company may be connected to disposable income. Using the information below regarding historical disposable income, predict the sales for 2020 using regression analysis if a reliable prediction for disposable income for 2020 is $21,200. Year Disposable Income  2013  $18,000  2014  $18,618  2015  $19,099  2016  $24,453 2017  $24,906 2018  $20,388 2019  $21,425     Year Sales 2013  $225,000 2014  $193,000 2015  $248,000 2016  $300,000 2017  $340,000 2018  $295,000 2019  $310,000

The manager Concerned about her current customer base, manager Andersen started to think of factors that might affect the attractiveness of an auditing firm. Of course, the service quality provided and the fees charged by the auditor seem two important factors. Next, she decides that the reputation of the auditing firm also needs to be included in the framework as an independent variable. As illustrated by the dramatic effects of recent auditing scandals, reputation seems especially important for large auditors (i.e., auditing firms that are large in size). Finally, manager Andersen also thinks that the proximity of the auditing firm to the customer is another variable to be included as an independent variable. Proximity very likely affects the possibility for the client to personally meet with the auditors on a regular basis and she knows from her own contact with customers that they perceive personal interactions as quite important. Consider the above scenario shown; answer the…

briefly discuss a method of data analysis

Total DVD and Blu-ray disc sales in 2009 were $8.72 billion. For the purposes of this problem, you will combine DVD and Blue-ray disk sales into one category of DVD sales. A study by In-Stat predicted that "physical disc sales will decline by $4.7 billion by 2014," and that "streaming, on the other hand, should grow from its current $2.2 billion to $6.3 billion over the same time period (2009–2014). d. Write an equation that represents the linear model for streaming videos. Let S = the total sales of streaming videos in billions of dollars, and t = the number of years after 2009. e. In what year do the models predict streaming video sales to exceed DVD sales?