Purchase Solution

The answer to Regression Analysis in megastat

Not what you're looking for?

Ask Custom Question

Please see attachment. The answer to the problem is attached.Please explain step by step how to calculate. A formula( what numbers to take) or can it be dome in excel? if it can what are the steps?

Purchase this Solution

Solution Summary

The solution provides step by step method for the calculation of regression model in Excel . Formula for the calculation and Interpretations of the results are also included.

Solution Preview

Computing the sample correlation coefficient and the coefficients for the least-squares regression line
A popular, nationwide standardized test taken by high-school juniors and seniors may or may not measure academic potential, but we can nonetheless examine the relationship between scores on this test and performance in college.
We have chosen a random sample of fifteen students just finishing their first year of college, and for each student we've recorded her score on this standardized test (from 400 to1600) and her grade point average (from 0 to4) for her first year in college. The data are shown below, with denoting the score on the standardized test and denoting the first-year college grade point average. A scatter plot of the data is shown in Figure 1. Also given are the products of the standardized test scores and grade point averages for each of the fifteen students. (These products, written in the column labelled " ," may aid in calculations.)

Figure 1

Answer the ...

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.