QuestionQuestion

Instructions for Exercises 12.2 (a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y? (b) Make an Excel worksheet to calculate SSxx , SSyy , and SSxy . Use these sums to calculate the sample correlation coefficient. Check your work by using Excel’s function =CORREL(array1,array2). (c) Use Appendix D to find t.05 for a two-tailed test for zero correlation.

(d) Calculate the t test statistic. Can you reject ρ = 0? (e) Use Excel’s function =TDIST(t,deg_freedom,tails) to calculate the two-tail p-value.

12.2 Part-Time Weekly Earnings ($) by College Students

Hours Worked (X) Weekly Pay (Y)
10 93
15 171
20 204
20 156
35 261

Instructions for Exercises 12.4–12.6: (a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient.

(c) Use Excel or Appendix D to find t.05 for a two-tailed test. (d) Calculate the t test statistic.
(e) Calculate the critical value of rα. (f) Can you reject ρ = 0?

12.4 Moviegoer Spending ($) on Snacks

Age (X) Spent (Y)
30 2.85
50 6.50
34 1.50
12 6.35
37 6.20
33 6.75
36 3.60
26 6.10
18 8.35
46 4.35

12.6 Number of Orders and Shipping Cost ($)

Orders (X) Ship Cost (Y)

1,068 4,489
1,026 5,611
767 3,290
885 4,113
1,156 4,883
1,146 5,425
892 4,414
938 5,506
769 3,346
677 3,673
1,174 6,542
1,009 5,088

12.8 (a) Interpret the slope of the fitted regression Sales = 842 − 37.5 Price. (b) If Price = 20, what is the prediction for Sales? (c) Would the intercept be meaningful if this regression represents DVD sales at Blockbuster?

12.10 The regression equation NetIncome = 2,277 + .0307 Revenue was fitted from a sample of 100 leading world companies (variables are in millions of dollars). (a) Interpret the slope. (b) Is the intercept meaningful? Explain. (c) Make a prediction of NetIncome when Revenue = 1,000.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Statistics Problems
    $23.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available General Statistics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats