How do I calculate this on Excel? Analyze whether higher discounts result in higher sales. Calculate the correlation between discount percentages and sales.
Added by Maria S.
Step 1
First, you need to have your data organized in Excel. Let's assume you have two columns: one for discount percentages (let's say column A) and one for sales (let's say column B). Show more…
Show all steps
Your feedback will help us improve your experience
Lottie Adams and 69 other Macroeconomics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Please show Excel formulas to work on this problem. Scenario: You are curious to see if there is a possible relationship between the number of promotions and total sales. You are provided with the following data: Number of Promotions Total Sales 8 1900 2 1300 3 1800 6 1500 7 1750 12 2934 10 2700 5 1900 11 2412 1 1200 15 3300 14 3100 9 2193 13 2852 4 1712 Create a scatter diagram. Be sure to include axis titles on your graph and a trend line with the equation. Run a linear regression using Excel's Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 7. You must show your work in order to earn credit for the predicted value. Is there a significant relationship? Clearly explain your reasoning using the regression results.
Adi S.
Supreeta N.
Please tell me how to solve in excel: We have taken a sample of 20 customers for a local credit union. The sample mean for the account balance is $3741.80 and the sample standard deviation is $5626.57. Find the lower bound of a 90% confidence interval estimate of the mean of the account balance.
Sri K.
Recommended Textbooks
Principles of Economics
Macroeconomics
Economics
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD