Consider the following data on 20 chemical reactions, with Y = chromatographic retention time (seconds) and X = molecular weight (gm/mole). Retention Time and Molecular Weight (n = 20)NameRetentionTimeMolecular Weightalpha-pinene 234.50  136.24 cyclopentene 95.27  68.12 p-diethyl benzene 284.00  134.22 decane 250.60  142.29 toluene 174.00  92.14 benzene 135.70  78.11 2-methyl pentane 97.24  86.18 2,3 dimethylbutane 100.70  86.18 1,7-octadiene 172.20  110.20 1,2,4-trimethyl benzene 262.70  120.19 2,3,4-trimethyl pentane 160.98  114.23 ethylcyclohexane 195.07  112.22 limonene 271.50  136.24 methyl cyclohexane 153.57  98.19 m-diethyl benzene 281.50  134.22 2,3-dimethyl pentane 131.83  100.20 2,2-dimethyl butane 89.34  86.18 pentane 78.00  72.15 isooctane 136.90  114.23 hexane 106.00  86.18     Click here for the Excel Data File (a) Write the fitted regression equation. (Round your answers to 4 decimal places. A negative value should be indicated by a minus sign.)  yˆy^ =  Not attemptedX + Not attempted (b) Calculate R2. (Round your answer to 4 decimal places.)  R2            Not attempted

Asked Feb 23, 2020

Consider the following data on 20 chemical reactions, with Y = chromatographic retention time (seconds) and X = molecular weight (gm/mole).


Retention Time and Molecular Weight (n = 20)

Name Retention
Molecular Weight
alpha-pinene   234.50     136.24  
cyclopentene   95.27     68.12  
p-diethyl benzene   284.00     134.22  
decane   250.60     142.29  
toluene   174.00     92.14  
benzene   135.70     78.11  
2-methyl pentane   97.24     86.18  
2,3 dimethylbutane   100.70     86.18  
1,7-octadiene   172.20     110.20  
1,2,4-trimethyl benzene   262.70     120.19  
2,3,4-trimethyl pentane   160.98     114.23  
ethylcyclohexane   195.07     112.22  
limonene   271.50     136.24  
methyl cyclohexane   153.57     98.19  
m-diethyl benzene   281.50     134.22  
2,3-dimethyl pentane   131.83     100.20  
2,2-dimethyl butane   89.34     86.18  
pentane   78.00     72.15  
isooctane   136.90     114.23  
hexane   106.00     86.18  


 Click here for the Excel Data File
(a) Write the fitted regression equation. (Round your answers to 4 decimal places. A negative value should be indicated by a minus sign.)
yˆy^ =  Not attemptedX + Not attempted
(b) Calculate R2(Round your answer to 4 decimal places.)
R2            Not attempted



Expert Answer

1 Rating
Step 1
  1. a) Line of best of the data:

The line that best fits the data is least-squares regression line.

The procedure to draw scatterplot with fitted line using EXCEL is as follows.

  • Select the data molecular weight (x) and retention time(y).
  • Go to Insert.
  • Select Scatter under Charts.
  • Right click on the obtained chart and select add trend line, check linear, Display Equation on chart, and Display R-squared value on chart.


Step 2

The scatter diagram with fitted line for the data that is obtained using EXCEL is as follows:

Statistics homework question answer, step 2, image 1


Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: Question 58

A: 58. Step 1 According to the provided information,


Q: Assume that hybridization experiments are conducted with peas having the property that for​ offsprin...

A: GivenThe probability that a pea has green pods = 0.75 = pThe total number of peas randomly selected ...


Q: A coin-operated soft-drink machine is designed to discharge, when it isoperating properly, at least ...

A: Click to see the answer


Q: a)What is the level of significance? (Enter a number.) State the null and alternate hypotheses. Will...

A: a) level of significance = 0.01 Null hypothesis : H0: µ = 4.2 % Alternative Hypothesis : H1: µ >...


Q: Find the indicated z score. The graph depicts the standard normal distribution with mean 0 and stand...

A: The normal distribution: A continuous random variable X is said to follow normal distribution with m...


Q: 2. There are three trails to the top of a mountain. In how many ways can a person hike up and down t...

A: According to the provided data, there are three trails available to the top of a mountain. a) The nu...


Q: The following sample observations were randomly selected. x 4 5 3 6   10 y 4 6 5 7   7   Fill in the...

A: The mean of the given data can be calculated as: Simillarly, Therefore, the mean is 5.6 and 5.8 fo...


Q: Cigarette Taxes The increases (in cents) in cigarette taxes for 12 states in a 6-month period are 60...

A: Range: The range is the difference between the largest and smallest observations in a set of data. T...


Q: Question 6 The salaries at a corporation are normally distributed with an average salary of $19,000 ...

A: The provided information are: Population mean (µ) = 19000 Population standard deviation (σ) = 4000 C...