Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. a. use excel to create a scatter plot of the data.

a. Use Excel to create a scatter plot of the data. What does it suggest...

50.1K

Verified Solution

Question

Finance

image

a. Use Excel to create a scatter plot of the data. What does it suggest about the correlation between X and Y?

b. Use Excel to calculate the correlation coefficient.

c. Use Excel to find t.025 for a two-tailed test at = .05.

d. Calculate the t test statistic.

e. Can you reject = 0?

Order Size and Shipping Cost (n = 12) Ship Cost Orders (X) 1,068 1,026 767 885 1,156 1,146 892 938 769 677 1,174 1,009 Ship Cost (Y) 4,489 5,611 3,290 4,113 4,883 5,425 4,414 5,506 3,346 3,673 6,542 5,088

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

0 CHALLENGE PROBLEM The Racitis own 300 shares of Clayton Manufacturing which they purchased at...

Basic Math
Q

The December 31, 2018, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Account...

Accounting
Q

Which of the following statements best describes a promoter? (multiple choice) 1.A set of adjacent structural genes...

Biology
Q

describe the stroke volume and the factors that affect it during rest and during exercise

Medical Sciences
Q

object m1 = 1.50 kg starts at an initial height h1i = 0.290 m and speed v1i...

Physics
Q

The intensity of an earthquake wave passing through the Earth is measured to be 2.5×106 J/m2⋅s...

Physics
Q

A distributor of computer parts purchases a specific component from a supplier in lots of 1000...

Basic Math
Q

I. A o the managers insisted on company who...

Accounting
Q

Cullumber Corporation purchased a patent for $153000 on September 1, 2016. It had a useful...

Accounting
Q

In need of help with completing the Balance Sheet for month end Oct.31 Custom...

Accounting
Q

Kop Corporation's 5-year bonds yield 6.80%, and T-bonds with the same maturity yield 5.15%. The...

Finance
Q

NON-CONSTANT GROWTH and then who thew

Accounting