1 answer

Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of...

Question:

Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of Y and values of X), create a scatter pх Y 25 15.7 22 22.6 32 10.7 8 31.3 14 23.7 12 45.1 16 42 9 41.4 25 8.6 10 51

Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of Y and values of X), create a scatter plot with the variable Y plotted vertically and the variable X plotted horizontally. You are to add a trendline, the equation of the line and R to this scatter plot. You do not need to add a title to this plot. b) Run the 'Regression' analysis tool (found under DATA/Data Analysis). The output using this tool should result in 3 tables. The values in the table are to be formatted to 5 decimal places except for number of observations and df's. Make certain that when your columns are wide enough so that no descriptions in your output are cut-off.
х Y 25 15.7 22 22.6 32 10.7 8 31.3 14 23.7 12 45.1 16 42 9 41.4 25 8.6 10 51

Answers

a) Scatter plot is obtained using Excel for which steps are as;

  • Enter the data in the spreadsheet.
  • Go to Insert>Charts>All Charts>Scatter>ok.
  • Click chart elements to add axis title and trendline.
  • Go to trendline options and select linear model.
  • At the end, check display equation and R-squared value on chart.
  • The output is shown below,

Scatter Plot 60 y=-1.5315x + 55.705 R2 = 0.6875 50 40 >30 20 10 0 0 Сл 10 15 20 25 30 35 х

b) The regression analysis is performed using Excel. Steps are as;

  • Enter the data in the spreadsheet.
  • Go to Data>Data Analysis>Regression>Ok.
  • Fill in the required columns and click Ok.
  • The output is obtained as:

SUMMARY OUTPUT Regression Statistics Multiple R 0.82914 R Square 0.68747 Adjusted R Square 0.64841 Standard Error 8.98779 Obs

.

Similar Solved Questions

1 answer
I know that the answer is a but what are the steps of solving it?? Q7....
I know that the answer is a but what are the steps of solving it?? Q7. A plane leaves the airport and flies 68.0° east of north and travels 170 km. Then it changes direction of motion to fly 48.0° south of east, and travels 230 km. Finally, it makes an immediate emergency landing on the gro...
1 answer
Explain about supplemented foods in Canada, validity of claims on these products, and possible health implications.
Explain about supplemented foods in Canada, validity of claims on these products, and possible health implications....
1 answer
What are the concentrations of #H_3O^+# and #OH^-# in oranges that have a pH of 3.7?
What are the concentrations of #H_3O^+# and #OH^-# in oranges that have a pH of 3.7?...
1 answer
A 170 cm sample of soil obtained from below the ground water table has a mass...
A 170 cm sample of soil obtained from below the ground water table has a mass of 300 g. When oven-dried, the mass is 210 g. What is the density of solid soil particles? (Formulae attached) Phase relationships in soils S, = WG p=Pa(1+w) p=GWm y'= 7 sat – Yw 1. =D, = {max e x100 emax - emin ...
1 answer
How do you find the center-radius form of the equation of the circle having a diameter with endpoints (0, -8) and (-6,0)?
How do you find the center-radius form of the equation of the circle having a diameter with endpoints (0, -8) and (-6,0)?...
1 answer
Calculate the average annual growth rates of the following countries below: Country 1980 2014 United States...
Calculate the average annual growth rates of the following countries below: Country 1980 2014 United States 29288 51958 Japan 19147 35574 Mexico 11954 15521 Indonesia 2249 9797 How long will it take the countries above to double their GDPs?...
1 answer
Invest 1,000,000 Bank A : $1=€1 Bank B: $1.8=£1 Bank C: £1 =€1.5 How much can...
invest 1,000,000 Bank A : $1=€1 Bank B: $1.8=£1 Bank C: £1 =€1.5 How much can you make ?...
1 answer
0.01 m 5. In an oil-drop experiment, two parallel conducting plates are connected to a power...
0.01 m 5. In an oil-drop experiment, two parallel conducting plates are connected to a power supply with a constant voltage of 100 V. The separation between the plates is 0.01 m. A 4.8x10-6 kg oil drop is suspended in the region between the plates. Use g = 10 m/s. a. What is the direction of the ele...
1 answer
Describe the importance of Phase I and Phase Il enzymes in toxicokinetics.
Describe the importance of Phase I and Phase Il enzymes in toxicokinetics....
1 answer
10. What is the price elasticity of demand at point B? (a) -3 (b) -0.33 (c)...
10. What is the price elasticity of demand at point B? (a) -3 (b) -0.33 (c) -0.05 (d) None of the above. 11. At which point is the price elasticity of demand unit elastic? (a) A (b) B (c) C (d) None of the above. Use the following information to answer Questions 10 and 11. Consid...
1 answer
1. A person first walked 30.0 km east, and then walked 20.0 km in a direction...
1. A person first walked 30.0 km east, and then walked 20.0 km in a direction that makes an angle of 35.0° north of east.Determine the magnitude of his total displacement. 2.A vector →A has a magnitude of 50.0 m and points in a direction 30.0° above the positive x-axis. A second vector,...
1 answer
3. Strawberry Tech expects net cash flows of $100,000 by the end of this year. Net...
3. Strawberry Tech expects net cash flows of $100,000 by the end of this year. Net cash flowS will stay the same if the firm makes no new investments. Now the firm has the opportunity to add a line of tablet computers to the business. The immediate outlay for this opportunity is $100,000, and the ne...
1 answer
What caused Pontiac's Rebellion?
What caused Pontiac's Rebellion?...
1 answer
History Bookmarks People Window Help 2 x New Tab 1281 0491 Question 19 ements Information about...
History Bookmarks People Window Help 2 x New Tab 1281 0491 Question 19 ements Information about a sample is given. Assume that the sampling distribution is symmetric and bell-shaped p-0.30 and the standard error is 002 Your answer is correct. (a) Indicate the parameter being estimated G Search or ty...
1 answer
How is dynamic equilibrium related to vapor pressure?
How is dynamic equilibrium related to vapor pressure?...
1 answer
Write c++ program In this assignment, you need to complete following tasks on 2D array of...
Write c++ program In this assignment, you need to complete following tasks on 2D array of randomly sales figures. Assume that you are the manager of coffee shop chain, and oversee 5 branches. ID of branches are 1 to 5. You already collected sales data for yesterday from each branch, in three cate...
1 answer
(a) Identify ALL zero-force members, if any, in the two trusses shown below: 10 kip 4...
(a) Identify ALL zero-force members, if any, in the two trusses shown below: 10 kip 4 10 kip 12 (b) Identify ALL two-force members, if any, in the two frames shown: 15kN 10 kN | تر 15 | کا Fixed EN *...