Question Use Regression under Data Analysis for the following 2 problems: 

Use Regression under Data Analysis for the following 2 problems:

***If you don’t see Data Analysis on your Excel, for older versions you can add it to your Tools pull-down menu by going to Tools, clicking on Add-Ins, and checking the first box for Analysis ToolPak. Now Data Analysis should show up as an option on the Tools pull-down menu.

***For the newest version of Microsoft Excel,
1. Click FILE (upper left corner), and then click Excel Options
2. Click Add-Ins, and then in the Manage box, select Excel Add-Ins
3. Click Go
4. In the Add-Ins available box, select the Analysis ToolPak, check box and click OK. If Analysis ToolPak is not listed in the Add-Ins available, click browse to locate it. If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
5. After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

Problem 1. To determine the relationship between a person’s stride and height, each is measured for 12 people with the following results:

x y
15 56
17 57
19 64
11 52
16 60
22 66
17 63
25 73
12 54
15 58
25 69
23 71

where x is the stride and y is the height.

Find the correlation coefficient, determine whether it is significant at the 0.05 level, find the regression equation and predict the height given a stride of 15.5 inches. Also include a scatter plot.

Problem 2. In order to calibrate a protein analyzer, a regression equation is determined between three independent variables and the dependent variable which is the protein. Each variable is measured for 15 samples with the following results:

Sample A B C Protein
1 -55.8 68.8 -42.2 11.3
2 -54.1 60.8 -41.7 13
3 -51 54.8 -40.6 13.7
4 -48.9 53.8 -38.5 13.8
5 -51.4 56.7 -41 13.9
6 -48.9 54.2 -37.9 13.9
7 -53.9 56.9 -43 14.2
8 -53.5 56.1 -43.5 14.2
9 -50.7 54.7 -40.3 14.2
10 -52.9 53.9 -42.4 14.4
11 -54.5 54.7 -44.2 14.9
12 -49.7 50 -39.7 15
13 -48.4 45.5 -39.8 15.7
14 -52.4 50.5 -43.8 15.8
15 -48.4 40.1 -40 17

Find the regression equation using A, B and C as the independent variables and Protein as the dependent variable.

For examples of these problems, go to START —> PROGRAMS —-> STATISTICS—->Excel Examples.exe

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.