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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

nsional Analysis and Co the Metric System on a bottle of medicine reads Each e...

Basic Math
1.2K views

omework Ch 13 INTEREST RATE Percent 05 9 S 4 3 2 0 0 Supply...

Medical Sciences
1.2K views

Hello, would you please show me what is the difference between throat , pharynx, and larynx ? it...

General Management
1.2K views

1. Why are modern firms generally not deeply vertically integrated? Modern firms have less risky alternatives to manage...

General Management
1.2K views

Question 2 A manager is trying to decide whether to build a small, medium, or large...

Biology
1.2K views

Select the best answer for the question 3 Cystic fibrosis is a recessive genetic disease...

Basic Math
1.2K views

If the reserve requirement for a bank is 20 how much can a bank loan...

Algebra
1.2K views

Finding the Domain and Range of a Quadratic Graph Determine the Domain and Range for...

Accounting
1.2K views

Estimate what the proper balance of the allowance for doubtful accounts should be as of...

Accounting
1.2K views

Which type of budgeting requests for investment in large assets such as buildings, renovations software...

Accounting
1.2K views

Exercise 1 - Extracting purchases: Tesla's ending inventory on December 31, 2016, was $953,675. Tesla's...

Accounting
1.2K views

PLEASE PUT SOLUTION IN THE SAME FORMAT AS THE IMAGE. THANK YOU! Exercise...