Purchase Solution

Create an excel worksheet to calculate SSxx,SSyy, SSxy

Not what you're looking for?

Ask Custom Question

(a) Make an Excel worksheet to calculate SSxx, SSyy, and SSxy. (b) Use the formulas to calculate the slope and intercept. (SEE Chart below)
Part-Time Weekly Earnings by College Students
Hours
Worked (X) Weekly
Pay (Y)
10 93
15 171
20 204
20 156
35 261

Purchase this Solution
Solution Summary

This solution provides calculations of SSxx,SSyy, SSxy and calculations of slope and intercept of the regression line.

Solution Preview

The answers are in the attached excel file. Apart from intercept and slope which the problem requires, correlation coefficient has also been calculated.

(a) Make an Excel worksheet to calculate SSxx , SSyy , and SSxy . (b) Use the formulas to calculate the slope and intercept. (SEE Chart below)
Part-Time Weekly Earnings by College Students

Hours Worked (X)                  Weekly  Pay ...

Purchase this Solution
Free BrainMass Quizzes
SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Motivation

This tests some key elements of major motivation theories.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • Sample Correlation

    Makes a) an Excel scatter plot. (b) an Excel worksheet to calculate SSxx , SSyy, and SSxy.

  • Regression analysis

    302361 Statistics: Calculate SSxx, SSyy, SSxy, Slope & Intercept, SSE, SSR, and SST 16) A) Calculate SSxx, SSyy, and SSxy. B) Calculate the slope and intercept. C) Calculate SSE, SSR, and SST. D) Use the sums to calculate the R2.

  • Bivariate Regression in Excel

    174322 Bivariate Regression in Excel (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.

  • Solving and analyzing simple regression question

    Correlation coefficient r = SSxy/√[ SSxx SSyy] = 54/√54*____ = ______ We see that √._____ = ._______.

  • T test for Significance of correlation & Scatter plot

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

  • steps on performing simple regression

    The following values have been calculated: SSxx= 707.1967 SSxy= 8435.9392 SSyy= 114003.8333 SSE= 13374.02264 x= 46.4496 y= 55.9167 Using the calculations given above: i) Derive the simple linear regression for this data and explain

  • Calculating Simple Linear Regression

    45732 Calculating Simple Linear Regression In fitting a least squares line to n=15 data points, the following quantities were computed: SSxx=55, SSyy=198, SSxy=-88, x-bar=1.3, and y-bar=35. a.) Find the least squares line. b.)

  • Regression analysis

    432073 equation and explanation given the following data x 3, 1, 4, 4, 5 y 2 -2, 5, 4, 8 Determine SSxx, SSxy, SSyy Please see the answers Step by step method for computing sum of squares are given is given in the answer.

  • Least Squares Fitting

    122296 Least Squares Fitting In fitting a least squares line to n=15 data points, the following quantities were computed: SSxx=55, SSyy=198, SSxy=-88, x-bar=1.3, and y-bar=35.

View More Related Solutions