Description of scatter diagram in excel

Assignment Help Basic Statistics

Reference no: EM1398479

Given the following data, create a scatter diagram (using Excel), click on the points as demonstrated in the Excel workbook, and have Excel place the regression equation and coefficient of correlation on the graph for you. Interpret the results (in English).

Years of Education Annual Income (000's)

6 10

7 13

8 15

7 14

9 16

12 21

11 22

14 20

16 19

20 45

13 35

15 36

Reference no: EM1398479

Questions Cloud

Define or give an example of a hypothetical construct : Define or give an example of a hypothetical construct. Explain why operational definitions are needed to define and to measure constructs.

Write strategies to overcome workforce shortages : The board of directors has asked that you give 750-word report detailing your strategies and suggestions to overcome workforce shortages and to enhance employee morale.

Confidence interval for the average hourly wage earned : Using a random sample of 100 workers, researchers calculate a 95% confidence interval for the average hourly wage earned by construction workers in the city of Boston. This interval they calculate is from $18 to $26.

Determine frequency of the allele after 10 generations : The water appears to be contaminated with radioactive waste. This has resulted in a highly accelerated mutation rate of 1/100 "A" alleles mutating to an "a" allele every generation.

Description of scatter diagram in excel : Given the following data, create a scatter diagram (using Excel), click on the points as demonstrated in the Excel workbook, and have Excel place the regression equation and coefficient of correlation on the graph for you. Interpret the results (i..

What percent of vehicles have better gas mileage : The 2010 Chevrolet Camaro with an eight-cylinder engine and automatic transmission has a combined gas mileage of 19 mpg. What percent of all vehicles have better gas mileage than the Camaro?

Relationship between political attitudes and income : A researcher studies the relationship between political attitudes and income. He/she finds that those with higher income are more conservative.

Explain way to affect companies to be socially responsible : Lliability limits for oil companies. This change would punish corporations financially. Is this best way to affect companies to be socially responsible?

Determine rate law for the reaction : The decomposition of N2O5 in CCl4 proceeds as follows: 2N2O5 --> 4NO2 + O2. The rate law is first order in N2O5. At 64 degrees Celsius, the rate constant is 4.82 x 10^-3 S^-1.

User Account

All Pages