Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Correlation help. Can you show me what type of formula I am supposed to use so that I can work it out on Excel. I

Correlation help. Can you show me what type of formula I am supposed to use so that I can work it out on Excel. I forgot how to do it and I wan to relearn it on Excel.

image text in transcribed
Correlation Assignment See videos given in the Instructions for completing tables below (Note: Do NOT change numbers in the table below) Insert Correlation table below Your Answer Month Region A Sales Region B Sales What is the r value? January 11825 14944 Is the correlation Weak/Moderate/High? February 12116 10057 March 11919 12302 What is the p-value April 12847 12264 Is the p-value signficant May 12768 14006 June 11061 11815 Write the results below (see video 2) July 10018 13272 There is a....... August 14655 10522 September 12049 11698 October 12769 12703 November 10686 14890 December 10947 11683 Insert Summary Output table below (p-value table - see video)

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

Physics For Scientists And Engineers

Authors: Raymond A Serway, John W Jewett

10th Edition

1337671711, 9781337671712

More Books

Students also viewed these Mathematics questions

Question

What are some diseases caused by misfolded proteins?

Answered: 1 week ago