HI MR/Mrs, I hope you able to solve this question, my student number ended by 4!

This dataset consists of people who have a chronic disease. Gender and age of the people are provided in the columns. Also the other columns give the information about whether they are doing sports or not, whether they are having a healthy diet or not, and whether they are smokers or not. They are given a treatment. Their lab scores before and after the treatment are given. Take alpha (significance level) as 0.05, where needed. Do every step in excel, or manually. You can use the calculator but R codes will not be accepted! For the hypothesis tests in Question 1 and Question 2: First step, write your hypothesis carefully, and in full sentences Ho : ............ . Hi: Second step, conduct your test Third step, compare your result with table Fourth step, write the result of your test, discuss the result Fifth step, indicate type-1 and type-2 errors in full sentences (For the first question, indicate them for item (a) but not item (b); For the second question, indicate them) . Question 1 (33p): Choose the one which is the last digit of your student id! 0. a. Do women have lab scores lower than 6.0 (before the treatment)? b. Do women have lab scores equal to 6.0 (before the treatment)? 0. a. Do women have lab scores lower than 6.0 (before the treatment)? b. Do women have lab scores equal to 6.0 (before the treatment)? c. Build a confidence interval for women's lab scores and show that it is in harmony with (b). 1. a. Do men have lab scores greater than 6.0 (before the treatment)? b. Do men have lab scores equal to 6.0 (before the treatment)? C. Build a 95% confidence interval for men's lab scores and show that it is in harmony with (b). 2. a. Do heathy eating people have lab scores lower than 5.5 (before the treatment)? b. Do heathy eating people have lab scores equal to 5.5 (before the treatment)? C. Build a 95% confidence interval for heathy eating people's lab scores and show that it is in harmony with (b). 3. a. Do non-heathy eating people have lab scores greater than 6.5 (before the treatment)? b. Do non-heathy eating people have lab scores equal to 6.5 (before the treatment)? c. Build a 95% confidence interval for non-heathy eating people's lab scores and show that it is in harmony with (b). b. Do people who smoke have lab scores equal to 7.0 (before the treatment)? c. Build a 95% confidence interval for lab scores of people who smoke and show that it is in harmony with (b). 8. a. Do people who are younger than 60 have lab scores lower than 5.0 (before the treatment)? b. Do people who are younger than 60 have lab scores equal to 5.0 (before the treatment)? c. Build a 95% confidence interval for lab scores of people who are younger than 60 and show that it is in harmony with (b). 9. a. Do people who are older than 60 lab scores greater than 6.5 (before the treatment)? b. Do people who are older than 60 lab scores greater than 6.5 (before the treatment)? C. Build a 95% confidence interval for lab scores of people who are older than 60 and show that it is in harmony with (b). Question 2 (25p): Does the treatment decreased their lab scores significantly? Here, do not use "lab score before treatment" and "lab score before treatment" columns. Instead, import a new column, called 'difference', which is the difference of them: "lab score after treatment - lab score before treatment". Then take your new column, and conduct your hypothesis test. Question 3 (21p): Determine hich distribution fits to the random variables: "X: smoking status", "Y:lab score before treatment" and "Z: time since diagnosis. Explain with reasons and their parameters. Unless you provide the explanation, you will not be able to get the points. So, implement the following steps for each variable: 3.a i. X is the..... ii. I expect ... distribution fits to X because X...........) iii. 3.b i. ii. Yis the..... I expect ... distribution fits to Y because Yo.........) 3.c i. ii. iii. Z is the..... I expect .... distribution fits to Z because Z .......(...) Question 4 (21p): a. Which one is more important? Type 1 or Type 2 error? b. What is power, what are the things which affects power? c. What is a confidence interval? what are the things which affects its width? Cla final_as_HMW_dataset - Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat ? ! AutoSum Calibri 12 1 Wrap Text General Fill - Paste * Cut E Copy Format Painter Clipboard BI U -a: Merge & Center $ - % .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select - Font E Alignment Number Cells Editing F J K L 1 age time since diagnosis 2 1 3 9 4 35 5 6 8 10 7 5 8 29 9 10.3 10 80 58 27 11 12 fic time since diagnosis A B D E id gender doing sports healthy diet smoker 1 M yes yes yes 2 F no no no 3 F no yes no 4M yes yes yes 5 M yes no no 6 M no yes no 7F no yes yes 8 F yes no no 9M yes no no 10 M yes yes no 11 F no yes yes 12 F no no no 13 F yes yes yes 14 M yes no yes 15 F no no no 16 M no no no 17 F yes yes yes 18 F yes no yes 19 M no yes no 20 F yes yes yes 21 M yes no no 22 M no no no 23 F no yes no Sheet1 G H lab scores before treatmentsb scores after treatme 56 4.3 3.5 75 12.4 6.7 34 4.5 4.2 40 6.7 6.9 67 7.8 5.6 56 8.9 8.0 45 5.6 4.5 59 10.5 71 6.7 6.3 45 5.4 6.5 80 6.2 5.0 36 17.9 9.6 56 6.5 6.0 71 7.8 9.4 54 12.5 8.1 66 11.2 8.1 78 5.4 6.5 32 8.7 5.6 65 7.8 5.6 48 8.9 8.0 78 6.7 6.3 69 5.4 6.5 56 4.3 3.5 71 13 14 3 11 43 15 16 24 17 16 64 13 18 19 20 21 6 22 16 16 40 23 24 4 III . - Cla final_as_HMW_dataset - Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat X Ruler Formula Bar Gridlines Headings Message Bar Show/Hide Zoom Normal Page Page Break Custom Custom Full Layout Preview Views Screen Workbook Views 100 100% Zoom to Selection Macros Split View Side by Side Hide ET Synchronous Scrolling Arrange Freeze All Panes - Unhide Unhide Reset Window Position Window New Window Save Switch Workspace Windows Zoom Macros 149 fix 1 B D E F G H j K L M N no no 56 4.3 4 yes no yes yes 72 76 43 3.5 6.7 5.0 4.2 yes yes yes 50 yes yes 67 yes no 22 40 no no 8.0 no yes yes 5.0 49 87 54 61 35 no no no 12.4 5.4 5.2 14.9 5.4 6.5 10.4 9.4 6.5 10.4 10.4 55 no no no 8 yes 83 11 yes no yes no no 67 8 yes no yes 75 5 no no no no 7.8 6.7 6.7 7.8 6.7 6.7 6.7 9.6 12.6 7.6 10.2 4.3 no no A 24 23 F 25 24 M 26 25 M 27 26 F 28 27 F 29 28 M 30 29 M 31 30 M 32 31 F 33 32 F 34 33 M 35 34 M 36 35 F 37 36 F 38 37 F 39 38 M 40 39 F 41 40 M 42 41 F 43 42 F 44 43 M 45 44 F 46 45 M 47 46 M 48 47 F 49 48 M CA KI Sheet1 70 56 49 9.4 yes no no no yes no 55 88 32 2 103 110 11 56 no no yes 10.7 12.4 8.0 13.9 6.7 no no 64 74 71 no yes yes yes yes yes 58 5.4 5.6 4 yes no no no 49 18 no no 45 9.4 9.5 10.2 yes yes 6 yes no 67 12 no no no 34 10.4 9.4 10.7 10.3 6.7 11.6 5.6 7.0 23 no yes yes 4.5 18 no no 45 37 65 yes no 25 7.8 6.0 yes yes 1 Ready 90% Type here to search D ) ENG 9:48 AM 5/27/2020 This dataset consists of people who have a chronic disease. Gender and age of the people are provided in the columns. Also the other columns give the information about whether they are doing sports or not, whether they are having a healthy diet or not, and whether they are smokers or not. They are given a treatment. Their lab scores before and after the treatment are given. Take alpha (significance level) as 0.05, where needed. Do every step in excel, or manually. You can use the calculator but R codes will not be accepted! For the hypothesis tests in Question 1 and Question 2: First step, write your hypothesis carefully, and in full sentences Ho : ............ . Hi: Second step, conduct your test Third step, compare your result with table Fourth step, write the result of your test, discuss the result Fifth step, indicate type-1 and type-2 errors in full sentences (For the first question, indicate them for item (a) but not item (b); For the second question, indicate them) . Question 1 (33p): Choose the one which is the last digit of your student id! 0. a. Do women have lab scores lower than 6.0 (before the treatment)? b. Do women have lab scores equal to 6.0 (before the treatment)? 0. a. Do women have lab scores lower than 6.0 (before the treatment)? b. Do women have lab scores equal to 6.0 (before the treatment)? c. Build a confidence interval for women's lab scores and show that it is in harmony with (b). 1. a. Do men have lab scores greater than 6.0 (before the treatment)? b. Do men have lab scores equal to 6.0 (before the treatment)? C. Build a 95% confidence interval for men's lab scores and show that it is in harmony with (b). 2. a. Do heathy eating people have lab scores lower than 5.5 (before the treatment)? b. Do heathy eating people have lab scores equal to 5.5 (before the treatment)? C. Build a 95% confidence interval for heathy eating people's lab scores and show that it is in harmony with (b). 3. a. Do non-heathy eating people have lab scores greater than 6.5 (before the treatment)? b. Do non-heathy eating people have lab scores equal to 6.5 (before the treatment)? c. Build a 95% confidence interval for non-heathy eating people's lab scores and show that it is in harmony with (b). b. Do people who smoke have lab scores equal to 7.0 (before the treatment)? c. Build a 95% confidence interval for lab scores of people who smoke and show that it is in harmony with (b). 8. a. Do people who are younger than 60 have lab scores lower than 5.0 (before the treatment)? b. Do people who are younger than 60 have lab scores equal to 5.0 (before the treatment)? c. Build a 95% confidence interval for lab scores of people who are younger than 60 and show that it is in harmony with (b). 9. a. Do people who are older than 60 lab scores greater than 6.5 (before the treatment)? b. Do people who are older than 60 lab scores greater than 6.5 (before the treatment)? C. Build a 95% confidence interval for lab scores of people who are older than 60 and show that it is in harmony with (b). Question 2 (25p): Does the treatment decreased their lab scores significantly? Here, do not use "lab score before treatment" and "lab score before treatment" columns. Instead, import a new column, called 'difference', which is the difference of them: "lab score after treatment - lab score before treatment". Then take your new column, and conduct your hypothesis test. Question 3 (21p): Determine hich distribution fits to the random variables: "X: smoking status", "Y:lab score before treatment" and "Z: time since diagnosis. Explain with reasons and their parameters. Unless you provide the explanation, you will not be able to get the points. So, implement the following steps for each variable: 3.a i. X is the..... ii. I expect ... distribution fits to X because X...........) iii. 3.b i. ii. Yis the..... I expect ... distribution fits to Y because Yo.........) 3.c i. ii. iii. Z is the..... I expect .... distribution fits to Z because Z .......(...) Question 4 (21p): a. Which one is more important? Type 1 or Type 2 error? b. What is power, what are the things which affects power? c. What is a confidence interval? what are the things which affects its width? Cla final_as_HMW_dataset - Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat ? ! AutoSum Calibri 12 1 Wrap Text General Fill - Paste * Cut E Copy Format Painter Clipboard BI U -a: Merge & Center $ - % .00 .00.0 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Sort & Find & Filter - Select - Font E Alignment Number Cells Editing F J K L 1 age time since diagnosis 2 1 3 9 4 35 5 6 8 10 7 5 8 29 9 10.3 10 80 58 27 11 12 fic time since diagnosis A B D E id gender doing sports healthy diet smoker 1 M yes yes yes 2 F no no no 3 F no yes no 4M yes yes yes 5 M yes no no 6 M no yes no 7F no yes yes 8 F yes no no 9M yes no no 10 M yes yes no 11 F no yes yes 12 F no no no 13 F yes yes yes 14 M yes no yes 15 F no no no 16 M no no no 17 F yes yes yes 18 F yes no yes 19 M no yes no 20 F yes yes yes 21 M yes no no 22 M no no no 23 F no yes no Sheet1 G H lab scores before treatmentsb scores after treatme 56 4.3 3.5 75 12.4 6.7 34 4.5 4.2 40 6.7 6.9 67 7.8 5.6 56 8.9 8.0 45 5.6 4.5 59 10.5 71 6.7 6.3 45 5.4 6.5 80 6.2 5.0 36 17.9 9.6 56 6.5 6.0 71 7.8 9.4 54 12.5 8.1 66 11.2 8.1 78 5.4 6.5 32 8.7 5.6 65 7.8 5.6 48 8.9 8.0 78 6.7 6.3 69 5.4 6.5 56 4.3 3.5 71 13 14 3 11 43 15 16 24 17 16 64 13 18 19 20 21 6 22 16 16 40 23 24 4 III . - Cla final_as_HMW_dataset - Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat X Ruler Formula Bar Gridlines Headings Message Bar Show/Hide Zoom Normal Page Page Break Custom Custom Full Layout Preview Views Screen Workbook Views 100 100% Zoom to Selection Macros Split View Side by Side Hide ET Synchronous Scrolling Arrange Freeze All Panes - Unhide Unhide Reset Window Position Window New Window Save Switch Workspace Windows Zoom Macros 149 fix 1 B D E F G H j K L M N no no 56 4.3 4 yes no yes yes 72 76 43 3.5 6.7 5.0 4.2 yes yes yes 50 yes yes 67 yes no 22 40 no no 8.0 no yes yes 5.0 49 87 54 61 35 no no no 12.4 5.4 5.2 14.9 5.4 6.5 10.4 9.4 6.5 10.4 10.4 55 no no no 8 yes 83 11 yes no yes no no 67 8 yes no yes 75 5 no no no no 7.8 6.7 6.7 7.8 6.7 6.7 6.7 9.6 12.6 7.6 10.2 4.3 no no A 24 23 F 25 24 M 26 25 M 27 26 F 28 27 F 29 28 M 30 29 M 31 30 M 32 31 F 33 32 F 34 33 M 35 34 M 36 35 F 37 36 F 38 37 F 39 38 M 40 39 F 41 40 M 42 41 F 43 42 F 44 43 M 45 44 F 46 45 M 47 46 M 48 47 F 49 48 M CA KI Sheet1 70 56 49 9.4 yes no no no yes no 55 88 32 2 103 110 11 56 no no yes 10.7 12.4 8.0 13.9 6.7 no no 64 74 71 no yes yes yes yes yes 58 5.4 5.6 4 yes no no no 49 18 no no 45 9.4 9.5 10.2 yes yes 6 yes no 67 12 no no no 34 10.4 9.4 10.7 10.3 6.7 11.6 5.6 7.0 23 no yes yes 4.5 18 no no 45 37 65 yes no 25 7.8 6.0 yes yes 1 Ready 90% Type here to search D ) ENG 9:48 AM 5/27/2020