Homework Help is Here – Start Your Trial Now!
Math
Probability
(a) Make an Excel worksheet to calculate SSxx SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Click here for the Excel Data File Hours Worked (X) ar ar BE BR ST xbar D₁ Do 9 13 16 22 32 Hours Worked (x₁) Part-Time Weekly Earnings ($) by College Students Weekly Pay (Y) (x₁-xbar)² (y₁ - ybar)² ybar 9 13 16 22 32 104 178 209 162 271 (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) SSxx Use your estimated slope and Intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to ter "0" wherever required. Negative values should be indicated by a minus sign. Do not round Intermediate calculations, but al answers should be rounded to 3 decimal places.) Weekly Pay (y₁) 104 178 209 162 271 SSyy Estimated Pay (9₂) (x₁-xbar)(y-ybar) SSxy V₁ - ŷ (V₁-ý,)² (9,- ybar)² (y₁ - ybar)²

(a) Make an Excel worksheet to calculate SSxx SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Click here for the Excel Data File Hours Worked (X) ar ar BE BR ST xbar D₁ Do 9 13 16 22 32 Hours Worked (x₁) Part-Time Weekly Earnings ($) by College Students Weekly Pay (Y) (x₁-xbar)² (y₁ - ybar)² ybar 9 13 16 22 32 104 178 209 162 271 (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) SSxx Use your estimated slope and Intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to ter "0" wherever required. Negative values should be indicated by a minus sign. Do not round Intermediate calculations, but al answers should be rounded to 3 decimal places.) Weekly Pay (y₁) 104 178 209 162 271 SSyy Estimated Pay (9₂) (x₁-xbar)(y-ybar) SSxy V₁ - ŷ (V₁-ý,)² (9,- ybar)² (y₁ - ybar)²

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter6: Ratio, Proportion, And Probability
Section6.2: Writing And Solving Problems
Problem 9C
See similar textbooks
icon
Related questions
Question
(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be Indicated by a minus sign. Round your answers to 2 decimal places.) Click here for the Excel Data File xbar ybar SSE SSR SST R² Hours Worked Weekly Pay (Y) (X) 104 178 209 162 271 xbar b₁ Do 9 13 16 22 32 Hours Worked (x;) Part-Time Weekly Earnings ($) by College Students (x; -xbar)² (y₁ - ybar)² ybar 9 13 16 22 32 (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Do not round Intermediate calculations, but final answers should be rounded to 3 decimal places.) SS.xx Weekly Pay (yi) 104 178 209 162 271 Estimated Pay (ŷ;) (d) Calculate the R2. (Round your answer to 4 decimal places.) 1 2 3 4 SSyy 5 6 7 8 9 10 A (x₁ - xbar)(y₁ - ybar) Vi- ý SSxy (V; - ŷ;)² (ŷ; - ybar)² Hours Worked (X) 9 13 16 22 32 с D E College Students' Part-Time Weekly Earnings (n = 5) (y₁ - ybar)² Weekly Pay (Y) 104 178 209 162 271 F
Transcribed Image Text:(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be Indicated by a minus sign. Round your answers to 2 decimal places.) Click here for the Excel Data File xbar ybar SSE SSR SST R² Hours Worked Weekly Pay (Y) (X) 104 178 209 162 271 xbar b₁ Do 9 13 16 22 32 Hours Worked (x;) Part-Time Weekly Earnings ($) by College Students (x; -xbar)² (y₁ - ybar)² ybar 9 13 16 22 32 (b) Use the formulas to calculate the slope and intercept. (Round your answers to 3 decimal places.) (c) Use your estimated slope and intercept to make a worksheet to calculate SSE, SSR, and SST. (Leave no cells blank - be certain to enter "0" wherever required. Negative values should be indicated by a minus sign. Do not round Intermediate calculations, but final answers should be rounded to 3 decimal places.) SS.xx Weekly Pay (yi) 104 178 209 162 271 Estimated Pay (ŷ;) (d) Calculate the R2. (Round your answer to 4 decimal places.) 1 2 3 4 SSyy 5 6 7 8 9 10 A (x₁ - xbar)(y₁ - ybar) Vi- ý SSxy (V; - ŷ;)² (ŷ; - ybar)² Hours Worked (X) 9 13 16 22 32 с D E College Students' Part-Time Weekly Earnings (n = 5) (y₁ - ybar)² Weekly Pay (Y) 104 178 209 162 271 F
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 120 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
SEE MORE TEXTBOOKS