Question: Use Excel to do a correlation between the following variables: 1) X 2,5,5,6,6,7,8,9 2) Y 1,2,2,3,4,4,5,5 Please compose a statistical analysis on the assignment

Use Excel to do a correlation between the following variables:

1) X 2,5,5,6,6,7,8,9

2) Y 1,2,2,3,4,4,5,5

Please compose a statistical analysis on the assignment

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!

Q:

a Incorrect Your answer is incorrect. There are two spinners containing only green and orange slices. Spinner A has 4 green slices and 12 orange slices. All the slices are the same size. Spinner B...

Q:

Please include how to calculate the math 1. What is the Illini Tap's weighted-average-cost-of-capital (WACC)? (10 pts.) 2. Calculate the NATCF series, and find the NPV of each investment using the...

Q:

Please help, it keeps saying the question is not complete and I'm very confused considering it wants an UNADJUSTED trial balance. I already have everything balanced for everything up to the 25th but...

Q:

Lamp Light Company maintains and repairs warning lights, such as those found on radio towers and lighthouses. Lamp Light Company prepared the following end-of-period spreadsheet at December 31, 2018,...

Q:

Please answer all questions, and make sure the arithmetic and final answer are correct. Question 1 (Essay Worth 10 points) (01.05) For fix) _ ' X and g:){) ' x , find the simplified form for f [g(x)]...

Q:

Chapter Review Problem #15) An elevator is loaded with16people and is at its load limit of2500pounds. What is the mean weight of these people? (Round to the nearest hundredth - two decimal places)...

Q:

[-/2.65 Points] DETAILS BBUNDERSTAT 12 3.3.005.MI. MY NOTES ASK YOUR TEACHER Consider the following ordered data. 2 5 5 6 7 7 8 9 10 (a) Find the low, Q1, median, Q3, and high. low Q 1 median Q3 high...

Q:

1) Based on the data shown below, calculate the correlation coefficient (to three decimal places). x y 5 37.22 6 34.23 7 34.84 8 31.25 9 25.96 10 23.37 11 20.58 12 19.69 13 16.2 2) At the 0.05...

Q:

I need help filling this out and with the questions besides #1 1 Time 2. 3 4 5 6 7 8 9 10 11 12 B SASMX US Equity FKASX US Equity DFFVX US Equity FDVLX US Equity IALAX US Equity 12/31/2010 25.2371...

Q:

Description A versatile scholar, Eratosthenes of Cyrene (today Libya) lived approximately 275195 BC. He was the first to estimate accurately the diameter of the earth. For several decades, he served...

Q:

A synapse is the junction between dendrites of two adjacent neurones. Its function is to allow the transmission of nerve impulses from neuron to neuron. With the aid of a well labelled diagram,...

Q:

After being observed many times, Bevarly Demarr, a hospital lab analyst, had an average observed time for blood tests of 10 minutes. Beverlys performance rating is 105%. The hospital has a personal,...

Q:

The forestfires.csv data base contains meteorological information and the area burned for 517 forest fires that occurred in Montesinho Natural Park in Portugal. The columns of interest are FFMC, DMC,...

Q:

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....