Question

5. XYZ Company recorded the following sales with their marketing budget for the past 12 years Markets 99 95 90105 110 108 125

0 0
Add a comment Improve this question Transcribed image text
Answer #1

f-CORREL(A2:A13,C2:C13) A16 Market Sales 1 Year Sales Vs Year 138 135 146 126 142 152 146 168 172 -0.0772x R2 0.0236 95 4 201

SUMMARY OUTPUT OF SALES VS YEAR ression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.884028SUMMARY OUTPUT OF SALES VS MARKET Regression Statistics Multiple RSau Chart Area Adjusted R Square Standard Error Observation

Add a comment
Know the answer?
Add Answer to:
5. XYZ Company recorded the following sales with their marketing budget for the past 12 years Mar...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following data represents the number of days absent and the final grade for a sample...

    The following data represents the number of days absent and the final grade for a sample of college students in a general education course at a large state university. 0 1 2 3 4 5 6 7 8 9 No. of absences Final Grade 89.2 86.4 83.5 81.1 78.2 73.9 64.3 71.8 65.5 66.2 a) Which variable is the explanatory variable? b) Draw a scatter plot and describe your scatter plot (Direction, Strength, Form). c) Compute the correlation coefficient d)...

  • 1. The following data represents the number of days absent and the final grade for a...

    1. The following data represents the number of days absent and the final grade for a sample of college students in a general education course at a large state university. No. of absences 0 1 2 3 4 5 6 7 8 9 Final Grade 89.2 86.4 83.5 81.1 78.2 73.9 64.3 71.8 65.5 66.2 a) Which variable is the explanatory variable? b) Draw a scatter plot and describe your scatter plot (Direction, Strength, Form). c) Compute the correlation coefficient....

  • BBA 403 TEST 3: Name: Score:_ SOLVE AND THOROUGHLY INTERPRET YOUR ANSWER 1. A marketing manager conducted a study to determine whether there is a linear relationship between many spent on adverti...

    BBA 403 TEST 3: Name: Score:_ SOLVE AND THOROUGHLY INTERPRET YOUR ANSWER 1. A marketing manager conducted a study to determine whether there is a linear relationship between many spent on advertising and company sales. The data are shown on the table below. Display the data in a scatter plot, calculate the correlation coefficient, state a conclusion, and interpret the result Adverstising Company Expense, (1000s of s) (1000s of ) 2.4 16 2.0 26 14 1.6 2.0 2.2 184 220...

  • Du Lissuil Aug 19, 2019 1. List the variables Sales and Ads in the data file...

    Du Lissuil Aug 19, 2019 1. List the variables Sales and Ads in the data file salad.xlsx on the LMS networks. Sales is the number of boxes of Cheerios sold by Kellogs during 12 sample periods and Ads is the expenditure on Cheerios advertising in million real US dollars. (a) Scatterplot Sales versus Ads. Please discuss the plot briefly. (b) Fit the following linear regression model by using the command Im( sales ads) in R. Sales, = Bo + B;...

  • Applied Econometrics Use the dataset attached on blackboard and answer the following questions: First study the...

    Applied Econometrics Use the dataset attached on blackboard and answer the following questions: First study the simple linear regression model for the heart attack death rates, on the only basis of the number of phones. Determine whether the number of phone is associated significantly with the heart attack death rate. Write the multiple linear regression model for the heart attack death rates on the basis of the number of phones and the proportion of saturated fat. Compute the associated least...

  • Problem 1 (Modified from Problem 11-12 on page 438). An article in the Journal of Environmental E...

    Problem 1 (Modified from Problem 11-12 on page 438). An article in the Journal of Environmental En- gineering (Vol. 115, No. 3, 1989, pp. 608-619) reported the results of a study on the occurrence of sodium and chloride in surface streams in central Rhode Island. The following data are chloride concentration y (in milligrams per liter) and roadway area in the watershed (in percentage) y4.46.6 9.710.6 10.810.911.8 12.1 14.3 0.19 0.15 0.57 0.700.67 0.63 0.47 0.70 0.60 y14.715.0 17.319.223.127.427.7 31.839.5...

  • Question 9 5 pts Major League Baseball Games The following scatter plot shows the number of...

    Question 9 5 pts Major League Baseball Games The following scatter plot shows the number of home runs versus the number of attendance (in 1000 people) for some randomly selected games. Attendance and Runs for 11 Baseball Games. 6 8 10 Runs 2 4 O 20 30 40 -50 Attandance x1000) The following shows the output generated by a software for the least-square regression line using this data: Simple linear regression results: Runs - 1.020 +0.1590 Attendance Sample size: 11...

  • 1. (55 points) The investigators are interested in asses the relationship between Systolic Blood Pressure (SBP)...

    1. (55 points) The investigators are interested in asses the relationship between Systolic Blood Pressure (SBP) in mm Hg and Age in years among Hypertensive Patients. Specif- ically, whether a patient's SBP can be predicted from his or her age. They selected n=122 patients at random from a medical record database in a hospital. Assume that the simple linear regression model is appropriate. The following table shows regression output of a simple linear regression model relating the SBP to the...

  • -+ Ft to page Page view 2. A doctor wanted to determine whether there is a Age versus HDL Cholest...

    -+ Ft to page Page view 2. A doctor wanted to determine whether there is a Age versus HDL Cholesterol relation between a male's age and his HDL (so-called good) cholesterol. He randomly selected 17 of his patients and determined their HDL cholesterol. He obtained the following data: (Use Minitab only for graphs. Show all the steps) HDL HDL Age, x Cholesterol,y Age, x Cholesterol, y 38 42 46 32 57 54 34 56 35 40 42 38 47 38...

  • 5.Correlation and Simple Regression by Hand Hourly Earnings in Dollars) $35 $15 $40 $30 $55 (Years...

    5.Correlation and Simple Regression by Hand Hourly Earnings in Dollars) $35 $15 $40 $30 $55 (Years of Education) 16 14 18 12 20 Be sure to show all of your calculations and to interpret your findings. That is, while you can use R to check your work, you must show all of the calculations below "by hand." Assume that the populations are normal. Compute the sample correlation coefficient (r) between hourly earnings and vears of education for this random sample...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT