Question

In: Statistics and Probability

Use the Excel directions below to create a scatterplot for the Temperature in Fahrenheit and the...

Use the Excel directions below to create a scatterplot for the Temperature in Fahrenheit and the number of cricket chirps per sec.

Temp 88.6 71.6 92.3 85.3 80.6 75.2 69.7 81 69.4 83.3 79.6 82.6 80.6 (x)
Chirps 20.5 16 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15 17.2 16 (y)

3.) Find the linear regression equation using Excel. Slope uses the equation =slope(highlight y column, highlight x column). Y-intercept uses the equation =intercept(highlight y column, highlight x column). Use the equation to create a row of predicted number of chirps.

4.) Create a row of residuals using Excel equation. Each residual answer can be found by subtracting the observed value and the predicted value.

5.) Find correlation coefficient (r ) by using the Excel equation =correl(highlight x column, highlight y column). Note here the x column comes first.

6.) State conclusion based on the correlation coefficient (r) and r- critical value (use charts in notes). Assume Ho: ρ = 0.

I NEED HELP TYPING AND SOLVING THIS ON AN EXCEL SHEET PLEASE!!!!

Solutions

Expert Solution

ANSWER:

The given data entered in EXCEL .

x y
88.6 20.5
71.6 16
92.3 19.8
85.3 18.4
80.6 17.1
75.2 15.5
69.7 14.7
81 17.1
69.4 15.4
83.3 16.2
79.6 15
82.6 17.2
80.6 16

The scatterplot for X and Y is given below:

3. Slope =SLOPE(B2:B14,A2:A14)=0.2162

Intercept=INTERCEPT(B2:B14,A2:A14)=-0.4486

slope 0.216129
intercept -0.44856

4.The residual

x 88.6 71.6 92.3 85.3 80.6 75.2 69.7 81 69.4 83.3 79.6 82.6 80.6
y 20.5 16 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15 17.2 16
Residuals 1.799501 0.9737 0.299823 0.412728 0.128536 -0.30437 0.084345 0.042084 0.849184 -1.35501 -1.75533 -0.20372 -0.97146

5. The correlation coefficient will be obtained by CORREL(A2:A14,B2:B14) formula and is =

0.842306

6.We can find the significant correlation value for the correlation coefficient at 13-2=11 df for 5% level is 0.5529. Since the calculated value of the correlation is 0.8423>the critical value, we reject the null hypothesis and conclude that the correlation coefficient is significant and not equal to zero.

The EXCEL worksheet is given below

x y Residuals
88.6 20.5 1.799501
71.6 16 0.9737 slope 0.216129
92.3 19.8 0.299823 intercept -0.44856
85.3 18.4 0.412728 Correlation 0.842306
80.6 17.1 0.128536
75.2 15.5 -0.30437
69.7 14.7 0.084345
81 17.1 0.042084
69.4 15.4 0.849184
83.3 16.2 -1.35501
79.6 15 -1.75533
82.6 17.2 -0.20372
80.6 16 -0.97146
x 88.6 71.6 92.3 85.3 80.6 75.2 69.7 81 69.4 83.3 79.6 82.6 80.6
y 20.5 16 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15 17.2 16
Residuals 1.799501 0.9737 0.299823 0.412728 0.12853581 -0.30437 0.084345 0.042084 0.849184 -1.35501 -1.75533 -0.20372 -0.97146

NOTE:: I hope this answer is helpfull to you......**Please suppport me with your rating

**Please give me"LIKE".....Its very important for me......THANK YOU


Related Solutions

Use the Excel directions below to create a scatterplot for the Temperature in Fahrenheit and the...
Use the Excel directions below to create a scatterplot for the Temperature in Fahrenheit and the number of cricket chirps per sec. Temp 88.6 71.6 92.3 85.3 80.6 75.2 69.7 81 69.4 83.3 79.6 82.6 80.6 (x) Chirps 20.5 16 19.8 18.4 17.1 15.5 14.7 17.1 15.4 16.2 15 17.2 16 (y) 3.) Find the linear regression equation using Excel. Slope uses the equation =slope(highlight y column, highlight x column). Y-intercept uses the equation =intercept(highlight y column, highlight x column)....
Temperature Converter Create a temperature conversion program that will convert the following to Fahrenheit: Celsius Kelvin...
Temperature Converter Create a temperature conversion program that will convert the following to Fahrenheit: Celsius Kelvin Newton Your program should take a character which represents the temperature to convert from and a value to be converted to using the following specification: C - Celsius K - Kelvin N - Newton In addition your program should take in the following character to exit the program: X - eXit the program The numeric input for your program should be of type double....
The temperature in degrees Fahrenheit and the number of emergency calls are shown below. Determine if...
The temperature in degrees Fahrenheit and the number of emergency calls are shown below. Determine if there is a relationship between the temperature and the number of emergency calls received. Use .05 significance. Number of Calls (Y) Temperature (X) 7 68 4 74 8 82 10 88 11 93 9 99 13 101 What is the p value and is it significant? Select one: a. .1898, no it is not significant. b. .0267, yes it is significant. c. .2162, yes...
Use the following scatterplot to answer the question below. A scatterplot has a horizontal axis labeled...
Use the following scatterplot to answer the question below. A scatterplot has a horizontal axis labeled "x" with values from 30 to 110 and a vertical axis labeled "y" with values from 30 to 110. The scatterplot has 15 points. A pattern goes up and right from (49, 43) to (94, 76). The points are as follows. (49, 50) (59, 60) (65, 43) (65, 71) (66, 51) (66, 76) (67, 69) (70, 65) (71, 75) (75, 59) (75, 65) (75,...
a. The probability that the temperature will fall below 32 degrees Fahrenheit on any given day...
a. The probability that the temperature will fall below 32 degrees Fahrenheit on any given day is 20%. If the temperature does fall below 32 degrees, then there is an 80% chance of ice/frost. What is the probability that on any given day, the temperature will fall below 32 degrees and there will be ice/frost? (Input answer as a decimal, rounded to three decimal places if necessary b.In the card game Pokemon, players must construct a 60-card deck to play...
Answer IN R CODE to get the following. Using the data below, Create a scatterplot of...
Answer IN R CODE to get the following. Using the data below, Create a scatterplot of y vs x Fit a simple linear regression model using y as the response and plot the regression line (with the data) Test whether x is a significant predictor and create a 95% CI around the slope coefficient. Report and interpret the coefficient of determination. For x=20, create a CI for E(Y|X=20). For x=150, can you use the model to estimate E(Y|X=150)? Discuss. Does...
Write a Temperature class that will hold a temperature in Fahrenheit, and provide methods to get...
Write a Temperature class that will hold a temperature in Fahrenheit, and provide methods to get the temperature in Fahrenheit, Celsius and Kelvin. The class should have the following field: ftemp – A double that hold a Fahrenheit temperature. The class should have the following methods: Constructor – The constructor accepts a Fahrenheit temperature (as a double) and stores it in the ftemp field. setFahrenheit – The setFahrenheit method accepts a Fahrenheit temperature (as a double) and stores it in...
1. Temperature in kelvins (K) is related to the temperature in degrees Fahrenheit (°F) by the...
1. Temperature in kelvins (K) is related to the temperature in degrees Fahrenheit (°F) by the equation Design a MATLAB program that will do the following a. Prompt the user to enter an input temperature in °F. b. Read the input temperature. c. Calculate the temperature in kelvins in a separate function d. Write out the results with two digits to the right of the decimal (Use the fprintf function). The results should go to the command window.
The sample data below shows the average temperature (x, in degrees Fahrenheit) and monthly heating bill...
The sample data below shows the average temperature (x, in degrees Fahrenheit) and monthly heating bill (y, in dollars) for 12 recent months. Use Excel to compute the correlation coefficient. Enter your answer as a decimal rounded to three places. Correlation coefficient = Average temperature Monthly heating bill 29 326 36 295 42 241 58 196 62 154 70 93 74 33 77 0 68 62 57 184 45 263 33 302
Answer IN R CODE please. Using the data below, Create a scatterplot of y vs x...
Answer IN R CODE please. Using the data below, Create a scatterplot of y vs x (show this) and fit it a simple linear regression model using y as the response and plot the regression line (with the data). Show this as well. Test whether x is a significant predictor and create a 95% CI around the slope coefficient. What does the coefficient of determinations represent? For x=20, create a CI for E(Y|X=20). Show this. For x=150, can you use...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT