Question: How do I insert this formula in to excel? Based on the above table, the following is calculated: X = Xi = 39967 - 9991.75

How do I insert this formula in to excel?

Based on the above table, the following is calculated: X = Xi = 39967 - 9991.75 n 4 i=1 34018 Y = - 8504.5 1=1 4 n n SSXX = X? Xi = 399388317 - 399672/4 - 48044.75 n SSyy = Yi = 289338526 - 340182/4 = 32445 i=1 SSxY = >XiVi- n i=1 [vi = 339868791 - 39967 x 34018/4= i=1 -30560.5 Therefore, based on the above calculations, the correlation coefficient is obtained as follows: SSXY VSSxx . SSYY -30560.5 = V48044.75 - 32445 = -0.774

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

How can I insert this formula in to excel? Based on the above table, the following is calculated: X = Xi = 39967 - 9991.75 n 4 i=1 34018 Y = - 8504.5 1=1 4 n n SSXX = X? Xi = 399388317 - 399672/4 -...

pleass hslp ms on hos to complete this assignment with the steps i also attached Font 10 N Company Name Actual Expenses Sheet First Two Quarters of 2021 February June Trends May Total lan Percent of...

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Experiment 3 Acceleration Due To Gravity Questions How do you compute an object's velocity from its position? How do you measure the acceleration of a mass as it falls under the influence of gravity?...

HOMEWORK #1: EXCEL CORRELATION ASSIGNMENT (10 Points) Purpose: This assignment will increase your understanding of the concept of "correlation" and provides practice using Microsoft Excel to enter...

Directions for Data Set 1: 1. Enter the data from the table above into an Excel spreadsheet. Label row 1 of columns A, B, and C with "Participant Number," "Hours of TV Watched," and "Happiness...

please show me the formula or how you get the answers please go down and take it look...i have taken new photo that is clear Accounting 365 Flex Budget Project Instruction BEFORE YOU NON HEAD CLOSELY...

can you please solve this in formula form on excel with the formulas written out so i can see where the answers cam from please! can can you please solve it in formula form as well show the formula...

According to the U.S. Bureau of the Census, 27% of U.S. adults are college graduates. In a stratified sample of 200 U.S. adults, approximately how many persons in each of the following categories...

Securities that can be used to adjust the risk of their existing security investments is an example of money market, capital market, or derivative security?

Consider the following actual and forecast demand levels for Big Mac hamburgers at a local McDonald's restaurant Day Monday Tuesday Wednesday Thursday Friday Actual Demand Forecast Demand 88.00 88.00...

Write a one-page summary outline listing three or four recommendations you would make with respect to each HR function (recruiting, selection, training, and so on) that you think Ron Brown should be...

2 Why might it be important to have elements that are not straightforwardly measurable? The car marker, Jaguar Land Rover, was taken over by Tata, an Indian Conglomerate in 2008. Shortly after the...

If you were Ron Brown, would you implement the professors recommendation addressing the presenteeism problemin other words, start paying for sick days? Why or why not?