Please refer to attached documents. Attach excel file to response so I can see formulas used.
A06 Multiple Linear Regression - X [ users.stat.ufl.edu/~winner/data/c X WileyPLUS X datacamp - Bing X + X C A Not secure | users.stat.ufl.edu/~winner/data/carpet_age.txt Not syncing Dataset: carpet_age. csv Source: J. Csapo, Z. Csapo-Kiss, T.G. Martin, S. Folestad, 0. Orwar, A. Tivesten, and 5. Nemethy (1995). "Age Estimation of Old Carpets Based on Cystine and Cysteic Acid Content," Analytica Chimica Acta, Vol. 300, pp. 313-320. Description: Age of 23 Old Carpet and Wool samples, and Cysteic Acid, Cystine, Methionine, and Tyrosine. Two samples are of unknown age, and Prediction Intervals were formed. Variables/Names Sample ID (sample_id) age (age) Cysteic Acid Level (cys_acid) cystine level (cys) Methionine Level (met) Tyrosine Level (tyr) carpet_age.cav Ka . .. Open file Show all X Type here to search O W ? ^ 0 0 0 / 1) ENG 2:14 PM 2021-04-02Macauley X carpet_age + M AutoSave O Off) Search Share Comments File Home Insert Draw Page Layout Formulas Data Review View Help Insert X LO Calibri AA ab Wrap Text General Ex AY O * 11 E Delete ~ $ ~ % " Conditional Format as Cell Sort & Find & Analyze Sensitivity Paste BIU ~ CE E Merge & Center ~ Formatting Table Styles Format Filter ~ Select v Data Sensitivity Font Alignment Number Styles Cells Editing Analysis A Clipboard i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... A1 X V fx sample_id T U V W X Z A B C D E F G H K L M N P Q R 5 1 sample_lage cys_acid cys met tyr 2 1.1 1750 4.39 0.97 0 3 1.2. 1600 4.3 1.03 0 4 1.3. 1600 4.27 1.21 0.02 0.15 5 1.4 . 1600 4.33 1.1 0.02 0.2 6 1.5. 1600 4.01 1.19 0.01 0.2 7 1.6. 1550 3.99 1.22 0.03 0.3 8 1.7. 1550 3.97 1.33 0.03 0.38 9 1 .8 . 1550 3.82 1.19 0.02 0.54 10 1.9 . 1500 3.93 1.22 0.03 0.53 11 1.10 1400 3.81 1.53 0.03 0.75 12 1.11. 1400 3.54 1.5 0.04 0.77 13 1.12. 1400 3.72 1.54 0.04 0.73 14 1.13 1400 3.65 1.43 0.05 0.89 15 1.14 1050 3.12 1.78 0.15 1.33 16 1.15 650 1.87 3.12 0.21 2.11 17 1.16. 400 1.49 3.21 0.28 2.32 18 2.19 400 1.53 3.43 0.27 2.29 19 2.20 300 1.32 3.82 0.31 2.31 20 2.21 250 1.21 3.79 0.29 2.43 21 2.22 170 1.19 4.15 0.33 2.37 22 1.17. 140 1.22 4.24 0.38 2.85 23 2.23 128 1.03 4.2 0.4 2.59 24 2.24 120 0.88 5.19 0.39 2.83 25 1.18 1.92 3.24 0.24 1.99 26 2.25. 1.44 3.91 0.34 2.38 27 D carpet_age + I + 80% Ready 2:15 PM Type here to search W X 2021-04-02A06 Multiple Linear Regression - X ODD ADM2623_A06_MLR.pdf X WileyPLUS X datacamp - Bing X + X G O File | C:/Users/macau/Downloads/ADM2623_A06_MLR.pdf Not syncing 1 of 3 Q + | 0 Page view | A Read aloud | Draw ~ Highlight Erase They 11 6 P I. Prepare the Worksheet a. Name the workbook as A06_firstname_lastname_ID_NUMBER.xIsx. b. Use template similar to the Simple Linear Regression assignment for your solution II. Perform Multiple Linear Regression: a. Using any one of the suggested methods to answer the following questions: i. Calculate D, y ii. Calculate estimated B's and their significance levels iii. Calculate multiple and adjusted R2, F stats and standard error of y iv . Write a narrative report (about 200 words) drawing your inferences V . Timely Submission with correct Step I III. Suggested Methods: i . data analysis tool pack in Excel ii. LINEST function in Excel iii. R Programming language Note: Type here to search O W X ? ~ O D () ENG 2:16 PM 2021-04-02
