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

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

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 Finance Questions!

Hello, i need assistance for my homework that i have attached here. The questions i need assistance are question 2,3,4, and 5. UNITED STATES INTERNATIONAL UNIVERSITY CHANDARIA SCHOOL OF BUSINESS...

Hi, I need help with accounting .I have attached the document. assist me with question 5 only UNITED STATES INTERNATIONAL UNIVERSITY CHANDARIA SCHOOL OF BUSINESS MASTER OF BUSINESS ADMINISTRATION...

Used Jaguars Uncle Bob owns a used car business that sales solely used Jaguars. He wants to develop a regression model to help predict the price he can expect to receive for the cars he owns. He...

A car safety association conducted tests to measure the stopping distances of a new model of car and collected the following measurements. Year 0 3 6 9 12 15 Number of Members 15200 20200 27000 35600...

Please show all work and answer all questions! Show work! The following homework questions are due by the end of the week (Sunday, Oct 9). All work should be shown and the assignment should be...

math stisctic 245 Show your work, the formulas used, and the substitutions to answer the questions about the following data: Can the number of times a college students eats out in a week be used to...

(f) Formulate a hypothesis test to determine whether there is a significant linear relationship between food expenditure and income. At what levels of significance would the null hypothesis be...

Speed/ Stopping Distance 20 64 20 62 20 59 30 114 30 118 30 105 40 153 40 171 40 165 50 231 50 203 50 238 60 317 60 321 60 276 Please use JMP or Excel to create a scatter plot for this data using the...

6. A random sample of ten professional athletes produced the following data where x is the number of endorsements the player has and v is the amount of money made (in millions of dollars}. No y y: x...

1. Can SAT scores predict college performance? Let x be a variable that represents (+4 points) SAT scores of a computer science major, and let y be a variable that represents a student's GPA upon...

If an aqueous solution has a hydrogen ion concentration of 10 -5 M, what is the concentration of hydroxylion? What is the pH

A piston cylinder contains 3 kg of air at 20oC and 300 kPa. It is now heated up in a constant pressure process to 600 K.

moral hazard is reduced by providing deposit insurance causes bankers to overstate the provision for loan loss account requires the FDIC to charge all banks a constant deposit insurances premium...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".