5)Happy Baby, a maker of baby foods, has found a high correlation between the aggregate company sales (in $100,000) and the number of births nationally the preceding year (one year prior). Suppose that the sales and the birth figures during the past eight years are
Sales U.S. births
Year ($100,000) in millions
1 6.1 2.9
2 6.4 3.4
3 8.3 3.5
4 8.8 3.1
5 5.1 3.8
6 9.2 2.8
7 7.3 4.2
8 12.5 3.7
The linear regression equation for sales and births is calculated as follows: y = 4.16x - 5.85. Forecast the sales in year 9. (Note that the units for all the numerical choices below are in $100,000s)
a. 46.15
b. Sales in year 9 can not be forecasted since we do not have the birth rate in year 9.
c. 5.8
d. 17.5
e. 31.59
f. 9.5
______________________________________________________________
6) Happy Baby, a maker of baby foods, has found a high correlation between the aggregate company sales (in $100,000) and the number of births nationally the preceding year (one year prior). Suppose that the sales and the birth figures during the past eight years are
Sales U.S. births
Year ($100,000) in millions
1 6.1 2.9
2 6.4 3.4
3 8.3 3.5
4 8.8 3.1
5 5.1 3.8
6 9.2 2.8
7 7.3 4.2
8 12.5 3.7
Name the independent and dependent variables given the correlation information.
a. "Births" is the independent variable and "Year" is the dependent variable.
b. "Sales" is the independent variable and "Year" is the dependent variable.
c. "Births" is the independent variable and "Sales" is the dependent variable.
d. "Sales" is the independent variable and "Births" is the dependent variable.
e. "Year" is the independent variable and "Sales" is the dependent variable.
_______________________________________________________________________
7) The seasonal indeces (relatives) for the months of January, February, and March are given as 1.10, 0.99, and 0.90, respectively. The sales of coffee cups in January, February, and March of 2012 were respectively 88, 99, and 108. Compute the deseasonalized sales data accordingly.
a. 96.8, 98.01, 97.2
b. 88, 99, 108
c. 80, 100, 120
d. Enough information is not given.
__________________________________________________________________
8) For the following data, construct the linear regression line to forecast future sales:
Week | Sales |
1 | 10 |
2 | 26 |
3 | 45 |
4 | 70 |
Select one:
a. y = -12 + 19.9 t
b. y = 12 - 19.9 t
c. y = 19.9 + 12 t
d. y= 19.9 - 12 t
e. y = 12 + 19.9 t
Answering the first question as per Chegg policy
Answer 5: Option F - 9.5
Explanation: We know that the linear trend equation is, Y = 4.16X - 5.85
where Y = Sales in ($ 100,000) and X = Number of births in last year (Millions)
For Year 9 forecast,
X = Number of births in 8th year = 3.7 Millions
Year 9 Forecast = 4.16X - 5.85
= (4.16 x 3.7) - 5.85
= 9.5
Hence Option F is correct
5)Happy Baby, a maker of baby foods, has found a high correlation between the aggregate company...
4.3 Analysis Assignment #4 Note 1: all assignments moving forward must adhere to the appropriate Six Step Process (SSP). As our study materials have specified, the SSP has 3 versions. Version 1 is to be used for all t-tests; for all correlation analyses and Version 3 is be used for all regression analyses. Note 2: The data sets for Q1, Q2 and Q3 below can be downloaded here. Week 4 Analysis Assignments.xlsx Q1: (30 points) Complete the following data analysis:...
QUESTION 7 The data set Beer Large, which can be found in StatCrunch Shared Data Sets, gives the Alcohol, Carbohydrates and Calories for different brands of beer. The explanatory variable is x + Carbohydrates and the response variable is Y - Calories. Use this information to answer: Calculate the correlation between carbohydrates and calories. (4 decimal places) Row vars varo var var 8 var9 var 10 2 الميا ABV 4.1 5.4 4.43 4.13 5.9 4.9 Carbs 2.6 13.7 5.8 5...
CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...