Question: 1. For the data show in this table a. Use Excel to create a scatter plot of the data. What does it suggest about the

1. For the data show in this table a. Use Excel

1. For the data show in this table

a. Use Excel to create a scatter plot of the data. What does it suggest about the correlation between Xand 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 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!

1. For the data show in this table 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...

Reconsider the example of choosing the advertising budget at VRX that is presented in Section 1.4. In addition to the VRX2000, VRX also has a higher-end virtual-reality headset, the VRX3000. This...

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

Health Source Hospital (HSH) has a standing contract with an air charter service to deliver critical medications throughout its service network. The contract calls for a fixed monthly payment plus a...

Reconsider the example of choosing the advertising budget at VRX that is presented in Section 1.4. In addition to the VRX2000, VRX also has a higher-end virtual-reality headset, the VRX3000. This...

The following information have been obtained from the records of Kenya King dealing with computer repairs week Computers repaired Costs incurred 1 310 23200 2 200 19500 3 600 23600 4 480 20220 5 400...

2. Regression Analysis Method Illustration one The following cost data has been obtained from the records of Olympia Computer Systems; a firm that assembles computers. Month Number of computers...

Use Excel to create a scatter plot for these two variables. Comment on whether you believe there is a relationship between percent changes in market indices and percent changes in interest rates. If...

Table 1: Quantity of Cars sold and Prices of cars (in thousands of Euros) - Sample 1 Product_id (Sample 1) Quantity (No. of Cars) Price (1,000 Euros) 9 50423 12.59318 10 45688 13.00866 11 427...

The most obese countries in the world have obesity rates that range from 11.4% to 74.6%. This data is summarized in Table 2.75. Use Excel to create Descriptive Statistics table for the data below....

Do you feel the bank is doing the right thing by increasing or decreasing their interest rates based on the potential of what the output gap might become or should they wait after it has increased or...

Use the calculator provided to solve the following problems: Consider an E distribution with 15 numerator degrees of freedom and 29 denominator degrees of freedom. Compute P (0.88

7 Consider the PivotTable on the Salespersons worksheet. What percentage of salaries are paid to the employees that hold a position of Salesperson? 9 6 . 8 5 % 3 0 . 7 0 % 1 0 0 . 0 0 % 1 7 . 6 1 % 3...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...