# 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 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

#### Similar Solved Questions

##### 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...
##### 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....
##### 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?...
##### 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 ...
##### 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)?...
##### 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?...
##### 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 ?...
##### 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...
##### Describe the importance of Phase I and Phase Il enzymes in toxicokinetics.
Describe the importance of Phase I and Phase Il enzymes in toxicokinetics....
##### 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. 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,...
##### What caused Pontiac's Rebellion?
What caused Pontiac's Rebellion?...