Question

Use the following data to relate defective units of a drug to active milligrams and degrees...

Use the following data to relate defective units of a drug to active milligrams and degrees of temperature with multiple regression.

Milligrams 3 2 5 4 6
Defects 8 7 9 10 11
Grades F 84 87 83 90 93

Homework Answers

Answer #1

using excel>data>data analysis>Regression

we have  

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.961719
R Square 0.924904
Adjusted R Square 0.849807
Standard Error 0.612766
Observations 5
ANOVA
df SS MS F Significance F
Regression 2 9.249037 4.624518 12.31623 0.075096
Residual 2 0.750963 0.375482
Total 4 10
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept -6.37408 6.780632 -0.94004 0.446428 -35.5488 22.80062
Milligrams 0.743958 0.213319 3.487539 0.073293 -0.17388 1.661795
Grades 0.141856 0.081092 1.749334 0.222339 -0.20705 0.490766

the regression equation is

Defects = -6.374 +0.744*milligrams +0.142*Grades

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88...
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88 84 5 76 58 6 66 79 7 75 73 8 94 93 9 66 65 10 92 86 11 80 53 12 87 83 13 86 49 14 63 72 15 92 87 16 75 89 17 69 81 18 92 94 19 79 78 20 60 71 21 68 84 22 71 74 23 61 74 24 68 54 25 76 97...
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades...
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the​ model? If a student scores 7878 on the​ midterm, what would you predict her grade on the final exam to​ be? Student Midterm Final Exam 1 75 64 2 85 91 3 80 68 4 88 83 5 76 60 6 67 80 7 78 74 8 95 94 9 67 61 10 93 87 11...
The Population Mean for daily high temperatures in Hawaii for the month of January is 80...
The Population Mean for daily high temperatures in Hawaii for the month of January is 80 degrees; however, the Population Standard Deviation is Unknown. A researcher tests whether mean January temperatures in Hawaii have been significantly higher over the last 9 years. The researcher calculates the mean temperature for the month of January for the years 2012 through 2020. The Sample Mean temperature for this 9-year period (sample) is 87 degrees. The researcher wants to maximize the Power of the...
**Using the information below. . . What is the Absolute Value of the Critical Value for...
**Using the information below. . . What is the Absolute Value of the Critical Value for the Coefficient of Skew to test the Assumption of Normality? The Population Mean for daily high temperatures in Hawaii for the month of January is 80 degrees; however, the Population Standard Deviation is Unknown. A researcher tests whether mean January temperatures in Hawaii have been significantly higher over the last 9 years. The researcher calculates the mean temperature for the month of January for...
The Data A central tenet to being a good instructor, I believe, is to be a...
The Data A central tenet to being a good instructor, I believe, is to be a reflective practitioner of your craft. From time to time I find it to be necessary to review and reflect on my work as an instructor from a grade perspective. On our moodle page you will find a link to a second word document titled “300 Grades”. This data sheet contains both the alphanumeric grade (page 1) and the numerical equivalent (page 2) for every...
Question 4 4. Find the median for the following data. 6, 7, 4, 5, 3, 7,...
Question 4 4. Find the median for the following data. 6, 7, 4, 5, 3, 7, 4 a. 3 b. 4 c. 5 d. 7 Question 5 5. Thirty automobiles were tested for fuel efficiency in miles per gallon. The following frequency distribution was obtained. Calculate the mean. Class Boundaries Frequency 7.5-12.5 6 12.5-17.5 5 17.5-22.5 2 22.5-27.5 15 27.5-32.5 2 a. 552 b. 20.33 c. 610 d. 25    Question 6 6. The grades for a trigonometry exam follow....
Day Units Inspected Units Defective 1 200 6 2 150 2 3 250 8 4 150...
Day Units Inspected Units Defective 1 200 6 2 150 2 3 250 8 4 150 0 5 200 3 6 200 4 7 250 9 8 150 1 9 250 7 10 150 2 11 100 1 12 250 6 13 200 4 14 100 0 15 250 7 16 100 1 17 200 5 18 200 3 19 250 10 20 200 4 21 200 4 22 100 0 23 250 7 24 200 4 25 100 1...
Compute the least-squares regression equation for the given data set. Use a TI-84 calculator. Round the...
Compute the least-squares regression equation for the given data set. Use a TI-84 calculator. Round the slope and y-intercept to at least four decimal places. x 10 6 8 14 −7 −1 7 −9 y 3 1 30 31 0 3 −3 −15 Send data to Excel Regression line equation: =y the data is the numbers connected to the x and y lines for x the numbers are 10, 6, 8, 14, -7, -1, 7, -9 for y the numbers...
PROBLEM 1: Analyze the following data using LINEAR TREND ANALYSIS. How many cars will be sold...
PROBLEM 1: Analyze the following data using LINEAR TREND ANALYSIS. How many cars will be sold in time period 13? USE EXCEL TIME PERIOD NUMBER OF CARS SOLD 1 70 2 80 3 66 4 74 5 64 6 76 7 72 8 83 9 82 10 76 11 84 12 80
Electrobat, a battery manufacturer, is investigating how storage temperature affects the performance of one of its...
Electrobat, a battery manufacturer, is investigating how storage temperature affects the performance of one of its popular deep-cell battery models used in recreational vehicles. Samples of 30 fully charged batteries were subjected to a light load under each of four different storage temperature levels. The hours until deep discharge (meaning ≤ 20% of charge remaining) were measured. The data is shown in the accompanying table. 0 degrees F (hrs to discharge) 30 degrees F (hrs to discharge) 60 degrees F...