Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Boutique Build Australia specializes in designing and building boutique houses for residential customers. It has been operating since 2002. The company is a new client, and they have requested your...

The 7 Domains Model is a simplified framework that company owners may use to determine whether their concept has commercial potential. The approach breaks down your concept into seven categories...

In Problem perform the indicated operations and reduce answers to lowest terms. 2 4 ? 16 x? + 4x

In a perfectly competitive industry, the market price is $25. A firm is currently producing 10,000 units of output, its average total cost is $28, its marginal cost is $20, and its average variable...

The firm operated at full capacity in 2002. During 2003, it expects sales to increase by 20 percent and dividends per share to increase to $ 1.10. Use the projected balance sheet method to determine...

3. Understand the implications of existing findings within the field of suspect interviews.

Technology often offers the potential of improving efficiency and effectiveness of transportation companies, but water carriers do not appear to have applied much new technology to improve their...

arduino help 4.2 Practice run-time debugging by fixing the following listing, so that the LED will blink like it was meant to. Note: you should be able to do this with two minor changes. void New...

Read the case study Malden Mills which explain that Sandra is confused about how she should compensate herself for her labor. Assume that she decides to pay herself a 15 percent commission instead of...

If you can help with me with all the questions. Please & Thank you Chapter 1 What Economics is About & Appendix A: Pre-Class & In-Class Activities Packet Name/I.D. Number:_ Section: Date: Part 1....

The company sold $900,000 of products on account [The product cost was $600,000}. It subsequently collected 90% of the amount owed by customers, The company paid the account payable balance in...

7 Public Goods [20 points} Some analysts see the North Atlantic Treaty Organization (NATO) as a provider of a public good called "common security\" to its members. Suppose we measure security in...

Your company is trying to decide on one of 2 options for a process improvement device. This device would improve the company process monetarily. See below for improvements: device original cost...

8) (15 pts) A state has just adopted the following state income tax: no tax on the first $25,000 earned, 2% on the next $25,000 earned and 3% of all additional earnings. Write a multiline function...

Using the table description and business rules on the following page, answer or perform the following: Identify the Primary Key of the table as it is currently shown. Identify all of the functional...

What are the before image (BFIM) and after image (AFIM) of a data item? What is the difference between in-place updating and shadowing, with respect to their handling of BFIM and AFIM?

Virtual Tourist provides ratings for hotels throughout the world. Ratings provided by 649 guests at the Sheraton Anaheim Hotel, located near the Disneyland Resort in Anaheim, California, can be found...

In recent years more people have been working past the age of 65. In 2005, 27% of people aged 6569 worked. A recent report from the Organization for Economic Cooperation and Development (OECD)...

1. Develop numerical summaries of the data. 2. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the price of the car. 3. Use...

Consider the following quadratic models: a. Graph each of these quadratic models, side by side, on the same sheet of graph paper. b. What effect does the first-order term (4x) have on the graph of...

Eye movement and spatial distortion. A study of how eye movement behavior can distort ones judgment of the location of an object was published in Advances in Cognitive Psychology (Vol. 6, 2010). The...

Suppose you fit the quadratic model a. Is there sufficient evidence to indicate that the model contributes information for predicting y? Test using a = .05. Write the hypotheses for the test. b. What...