Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Excel and Data Analysis, you must enter the data given below and establish whether there is any relationship between the promotion and sales and

Using Excel and Data Analysis, you must enter the data given below and establish whether there is any relationship between the promotion and sales and establish why or why you do not consider that said answer is correct.

Suppose you have a Marketing team under your charge, one of the analysts brings you the following information so that you can analyze it and determine if there is any relationship between the variables.

Promotion

Sales

10000

25000

15000

23000

20000

21000

25000

30000

In light of these four data, go to Excel and using Data Analysis, perform a correlation analysis between the variables and determine whether or not there is indeed a relationship between the two.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Statistics For Business And Economics

Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam

7th Edition

1305081595, 978-1305081598

More Books

Students also viewed these Economics questions