Develop a separate scatter diagram for each set of data

Reference no: EM131223233

Problem -

An electronics store provides the following data regarding the number of advertisements and the number of TV's sold during an eight week period. Determine the correlation coefficient between the number of advertisements and the number of TV's sold. Also, provide a graphical representation of the data below.

WEEK	1	2	3	4	5	6	7	8
# of Advertisements	12	30	10	20	45	36	25	21
# of TV's Sold	25	38	18	25	57	30	32	23

1. Develop a separate scatter diagram for each set of data (Week # vs. # of Advertisements and Week# vs. # of TV's sold).

2. Show the line of best fit for each set of data (Week # vs. # of Advertisements and Week# vs. # of TV's sold).

3. Define the equation for the line of best fit for each set of data (Week # vs. # of Advertisements and Week# vs. # of TV's sold) and the correlation coefficient, r, for each.

4. Prepare a figure which shows the scatter diagram and line of best fit that shows the relationship between the # of Advertisements and the # of TV's sold.

5. Define the equation for the line of best fit and its correlation coefficient for the Figure prepared in item "d" above.

6. Given the equation and correlation coefficient which you have determined in item "e" above, describe the conclusion which you draw concerning the relationship between the number of Advertisements and the number of TV's sold.

You may use Excel and/or Power Point or other tools to address the items above.

Reference no: EM131223233

Questions Cloud

Benefits and drawbacks of using software development : Explain the benefits and drawbacks of using software development tools provided by cloud vendors to develop cloud-based solutions for an organization.

Types of networks are multiplexing technologies : What types of networks are multiplexing technologies most commonly used and what capabilities does it provide to users and providers?

How would you expect the monetary policy reaction curves : The FOMC has a dual objective of price stability and high economic growth. How would you expect the monetary policy reaction curves of the two central banks to differ? Why?

Benefits and drawbacks of using software : Explain the benefits and drawbacks of using software development tools provided by cloud vendors to develop cloud-based solutions for an organization.

Develop a separate scatter diagram for each set of data : An electronics store provides the following data regarding the number of advertisements and the number of TV's sold during an eight week period. Develop a separate scatter diagram for each set of data (Week # vs. # of Advertisements and Week# vs. # ..

How the long run real interest rate will change : Draw a diagram of aggregate expenditures showing this initial equilibrium. - Show how the long-run real interest rate will change and explain your results.

Internet and use of communication impacted the outcome : 1. How has the Internet and use of communication impacted the outcome of war(s)?

Develop strategies to advance career using your strengths : Develop strategies to advance your career using your strengths. How can you use goal-setting to increase motivation and improve job performance? How might your engagement as an employee and job satisfaction influence job performance?

What is the long run real interest rate : AE is aggregate expenditures and r is the real interest rate expressed as a decimal. - What is the long-run real interest rate?

User Account

All Pages