Question

In: Statistics and Probability

Show all calculation details by not using a calculator or Excel answers. Consider the data set:...

Show all calculation details by not using a calculator or Excel answers. Consider the data set: (7,11), (10,0), (13,-2).

A. Compute and interpret the coefficient of correlation.

B. Compute the least squares line for this data (no need to repeat computations from above).

Expert Solution

Given data:

x	y
7	11
10	0
13	-2

A.) The correlation coefficient is claculated as,

Here, n=3

Hence, we get,

Therefore, r= -0.9286 . Here, negative sign represents that there is a negative correlation between X and Y. Also the magnitude 0.9286 is close to 1, hence there is a perfect negative correlation.

B.) To fit least square line, which is given as,

where a and b are calculated as,

Therefore, the least square line for this data :

orchestra answered 1 year ago

show the student's calculator set-up (using the variables from a financial calculator) and answers for each...

show the student's calculator set-up (using the variables from a financial calculator) and answers for each of the 3 parts in the problem. For part c, give an exact percentage answer and not an approximate answer. Clearly identify your answers to each part. Assume that you just won the state lottery. your prize can be taken either in the form of 40000 at the end of each of the next 25 years (that is 1,000,000 over 25 years) or as...

Please show all steps using data set below and excel. By using a bivariate regression trend...

Please show all steps using data set below and excel. By using a bivariate regression trend line model, forecast total houses sold for the next five years. Prepare a time series plot of these data (years are on the x axis, THS is on the y axis) that shows both actual and forecast THS for the next five years. Total Houses Sold Year Northeast 1996 74.00 1997 78.00 1998 81.00 1999 76.00 2000 71.00 2001...

(show step by step calculation and formula, no excel or fina calculator) Based on the below...

(show step by step calculation and formula, no excel or fina calculator) Based on the below cash flows, HappyBear Ltd. uses the NPV decision rule. At a required return of 12 percent, should the firm accept this project? What if the required return is 30 percent? Year Cash Flow 0 -$32,000 1 16,000 2 20,000 3 17,000

Using the following data: (Pleae prove answers in excel spreadship & show calculations) • Initial Investment...

Using the following data: (Pleae prove answers in excel spreadship & show calculations) • Initial Investment = $10,000,000 • Cash Inflow – Year 1 = $3,000,000 • Cash Inflow – Year 2 = $3,500,000 • Cash Inflow – Year 3 = $4,000,000 • Cash Inflow – Year 4 = $4,900,000 • Cash Inflow – Year 5 = $5,000,000 a. Calculate Internal Rate of Return b. Calculate Net Present Value (assuming a required return of 8%) 2). Using the following data:...

Using the data provided in the excel file, show all of your work for the following...

Using the data provided in the excel file, show all of your work for the following calculations: a.) mean temperature of unmixed reagents (oC) b.) δελταT from graph (oC) c.) q absorbed by reaction mixture (J) d.) q absorbed by calorimeter, stirrer, and thermometer (J) e.) q total absorbed (J) f.) q total released (J) g.) calculation to show limiting reagent h.) deltaH neutralization for the reaction (kJ/mole of acid) A student reacted 100.0 mL of 0.9800 M HCl with...

For the following problems show your steps if using a financial calculator or upload the excel...

For the following problems show your steps if using a financial calculator or upload the excel spreadsheet if using excel. You just purchased a $1,000 par value bond with a 10 percent annual coupon rate and a life of 20 years. The bond has four years remaining until maturity, and the yield to maturity is 12 percent. How much did You pay for the bond? Is it a premium or discount bond? A $1,000 par value bond, paying $50 semiannually,...

Sample statistics: For the following data set, show all details of your calculations: {9, 6, -1,...

Sample statistics: For the following data set, show all details of your calculations: {9, 6, -1, 2, 0, 5, 8,3}. a) the median b) the standard deviation c) Q3. Give an explanation of the method you used to calculate the quartile. **There are a number of choices.**

Generate all substrings of set {1, 2, 3} using the bit strings method. Show details of...

Generate all substrings of set {1, 2, 3} using the bit strings method. Show details of your work.

Use EXCEL and DATA ANALYSIS to find the answers to these questions. Provide all EXCEL printouts...

Use EXCEL and DATA ANALYSIS to find the answers to these questions. Provide all EXCEL printouts and 6 step write-ups for each of the two problems. A food company is concerned about recent criticism of the sugar content of their children’s cereals. The data show the sugar content (as a percentage of weight) of 15 national brands of children and adult cereals. Children’s Cereal’s Adult’s Cereal 40.3 20.5 55 30.2 45.7 22.2 43.3 27.5 50.3 34.4 45.9 22.2 53.5 16.6...

Please show all your work if you use the Calculator. If done in Excel, please send...

Please show all your work if you use the Calculator. If done in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon...