Business
Engineering
Math
Science
Social ScienceThe following table presents monthly interest rates, in percent, for 30 year and- 15 year fixed-rate mortgages, for a recent year.30 Year 15 year 30 year 15 year3.92 3.20 3.55 2.853.89 3.16 3.60 2.863.95 3.20 3.47 2.783.91 3.14 3.38 2.693.80 3.03 3.35 2.663.68 2.95 3.35 2.66a. Construct a scatter plot of the 15- year rate (y) versus the 30-year rate (x).b. Compute the correlation coefficient between 30-year and 15-year rates.
The following table presents monthly interest rates, in percent, for 30 year and- 15 year fixed-rate mortgages, for a recent year.
30 Year 15 year 30 year 15 year
3.92 3.20 3.55 2.85
3.89 3.16 3.60 2.86
3.95 3.20 3.47 2.78
3.91 3.14 3.38 2.69
3.80 3.03 3.35 2.66
3.68 2.95 3.35 2.66
a. Construct a scatter plot of the 15- year rate (y) versus the 30-year rate (x).
b. Compute the correlation coefficient between 30-year and 15-year rates.
Expert Answer
- Scatterplot of the 15-year rate (y) versus the 30-year rate (x).
Software Procedure:
Step-by-step software procedure to draw scatter plot using Excel software is given below:
- Open an EXCEL file.
- In column A and B, the 30-year and 15-year data were entered.
- Select the data > click on insert.
- Chose X Y (Scatter) from chart.
- Click OK.
- Click on the data points>right click> add trend line.
- Choose
The scatterplot of the data obtained using software is given below:
Image Transcriptionclose
Scatter plot for 15-year (y) versus 30-year (x) 3.5 3 2.5 2 1.5 1 0.5 0 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 30-year 15-year
In the scatterplot, if the points lie along the straight line then there exists a linear relationship between the variables x and y.
b. Correlation coefficient between 30-year rate and 15-year rate:The sample correlation coefficient can be obtained using EXCEL. Enter the values of x and y in two columns, say in columns A2:A13 and B2:B13 in an EXCEL sheet. I...
Image Transcriptionclose
fx CORREL(A2:A13, B2:B13) F G H 0.996344 LL
Math
Statistics
Hypothesis Testing
Related Statistics Q&A
Find answers to questions asked by student like you
Show more Q&A addQ: Biologists conducted experiments to determine whter a deficiency of carbon dioxide in the soil affec...
A: For the given data, measures of center can be obtained.Mean: Arithmetic mean is the center value of ...
Q: Kim is playing scrabble. What is the probability she chooses the tiles with the letters of her name,...
A: Click to see the answer
Q: N = 19 Stem-and-leaf of Spread 0 1 1 0 89 3 1 03 5 (6) 1 555688 8 2 2 3 12 8 3 6 6 4 012 4 69 2 Leaf...
A: Stem- and- leaf plot:The stem and leaf plot is a table that divides the data points into stem and le...
Q: The problem is "Twelve percent of the job applicants for a large company have recently smoked mariju...
A: The provided information are:Percentage of applicants that have smoked marijuana, P (M) = 0.12Percen...
Q: There are 2 identical sets of data. The highest value of set b is 3 times than the highest value of ...
A: Measures of center:Mean:The arithmetic mean (also called the mean) is the most commonly used measure...
Q: 1) You have a sample of 9 flowers from pea plants. (a) Suppose 7 of them are white, and 2 of them ar...
A: From the given information,Number of flowers in a pea plant = 9
Q: 2) Here are some data on height (in meters) of mature sycamore trees. Construct a boxplot of these d...
A: Hello there! there are more than one question. According to our policies we cannot answer more tha...
Q: are there two different ways to find the mean? are there two different formulas to find mean? i hav...
A: Yes, there are two ways to find the arithmetic mean, one for ungrouped data or raw data (given data ...
Q: Find z such that the proportion of observations that are less than z in a standard normal distributi...
A: The normal distribution:A continuous random variable X is said to follow normal distribution with me...
