Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Quan 5500 Final Spring 2021 You may ONLY use internet help for running XLStat or Minitab if needed

Quan 5500 Final Spring 2021 You may ONLY use internet help for running XLStat or Minitab if needed

Statistics

Quan 5500 Final Spring 2021 You may ONLY use internet help for running XLStat or Minitab if needed. (Note that these should ONLY be needed if you do not meet required conditions and choose to run nonparametric techniques. IF you do not know what I am talking about, please be sure you read the Final info page. Otherwise, use only materials provided during the course. While not required, I am happy to verify your choice of tests for each question and I highly encourage it!! Please only send within the body of an email for verification; do not send attachments. If you do not have the correct test choice, I will help you work through it, but I expect some thought before you ask for verification, and some thought before you ask a second time. I will not engage in a “process of elimination” approach. BUT!! That said, please do ask whatever questions and let me decide what I will answer!! It is due as stated in the schedule document. Following is a study description followed by three research questions and an outline of requirements for you to follow in answering them. Each of you will only need to answer each research question for 2 of the health measures variables, which will be assigned individually. Nutrition education programs, which teach clients how to lose weight, reduce cholesterol intake, or reduce fat intake through better eating patterns, have been growing in popularity. The nurse in charge of one such program at a local hospital wanted to know whether the programs actually work to improve health measures. A random sample was drawn of 66 clients who attended a nutrition education program. The study recorded the following health measures: weight, cholesterol levels, total dietary fat intake per average day, total dietary cholesterol intake per average day, and percent of daily calories from fat. These data were gathered both before the program started and 3 months after the program. The researcher also determined the clients’ genders, ages, and heights. The data are stored in the following way: Column A: Gender (1 = female; 2 = male) Column B: Age Column C: Height (in feet) Columns D and E: Weight, before and after (in pounds) Columns F and G: Cholesterol Level, before and after Columns H and I: Total Dietary Fat Intake per average day, before and after (in grams) Columns J and K: Dietary Cholesterol Intake per average day, before and after (in milligrams) Columns L and M: Percent Daily Calories from fat, before and after (Adapted from Keller, Statistics for Management and Economics) Each of you should have already received 2 assigned health measures variables. For each of the variables you are assigned, answer the following research questions. Consider each heath measures variable individually. Do not try to incorporate both of your variables into one test for any of the research questions. Also, be aware that you may need to reorganize the data to run the tests and/or create new variables. Remember that required conditions are dependent on the test chosen, so you MUST decide the test for each question BEFORE you check required conditions. You WILL have separate required conditions for each research question! Quan 5500 Final Spring 2021 a) In terms of each of the health measures (weight, cholesterol level, fat intake, cholesterol intake, calories from fat), is there enough evidence to conclude that the program is a success? b) Can the researchers conclude that age impacts the amount of reduction in each measure (weight, cholesterol level, fat intake, cholesterol intake, calories from fat)? c) Do males and females differ in the amount of reduction for each measure (weight, cholesterol level, fat intake, cholesterol intake, calories from fat)? Your answer should be written in narrative form with appropriate graphs and output included as needed and should be submitted in one Word document. Please include page numbers and your name in the document. (I plan to print these, so this helps). I don’t use a rubric to grade these. You should use Excel for all your analysis and the p-value criteria to make your decisions. I do not need to see the seven-step hypothesis testing process, but be sure you include everything I specify below: There is no Rubric, Your write up must include: • A brief overall introduction describing the case including your chosen alpha. I do not need a detailed justification for your alpha, but it must be stated here. • For each research question, for each of your variables, you must include: 1. A statement of the test chosen and a clear and complete explanation for why you chose that specific test. This needs to be more than simply running through the flowchart steps and must show that you clearly understand why that is the correct choice. 2. Any analysis required to check for outliers. 3. Any analysis required to check the required conditions for your chosen test. Include any histograms or hypothesis tests and your decision based on these tests. (NOTE that if you find that you cannot meet the required conditions for the test you expected to do, you must use the appropriate non-parametric test. 4. A clear statement of your hypotheses, using proper symbols and notation. 5. Your Excel output for the test for each variable pasted into the document with the pvalues you used clearly identified 6. A clear statement of your conclusion for each hypothesis test and research question • An overall conclusion pulling everything together. Have Fun! Thanks for a Great Semester!! Variables for Final Your assigned variables are: Fat intake and calories from fat Gender Age 1 1 1 1 2 1 1 1 1 1 2 2 2 1 1 1 1 1 1 2 1 2 1 1 2 2 2 1 1 1 1 2 2 2 2 2 2 2 2 2 1 2 2 1 2 2 2 2 2 2 1 1 1 2 Height 46 56 54 50 61 40 42 68 64 40 42 68 69 44 49 37 64 54 35 50 55 35 37 52 42 58 60 48 47 47 37 47 57 50 35 53 53 54 66 42 49 48 49 27 58 53 63 46 59 61 55 40 56 50 5.59 5.57 4.90 5.03 6.01 5.76 5.30 5.53 5.40 5.61 5.84 5.96 5.37 5.14 5.03 5.82 5.62 5.11 6.03 5.75 5.49 4.97 5.07 5.35 5.81 5.56 4.92 5.01 5.38 5.13 5.56 5.77 5.39 5.37 5.41 5.91 5.44 5.59 5.58 5.04 5.18 5.68 5.44 5.38 5.75 5.46 5.84 5.05 5.55 5.40 5.42 5.57 5.26 5.23 Weight 1 Weight 2 CholLevel 1 CholLevel 2 Total Fat Intake 1 71.63 136.59 6.87 4.20 18.93 73.06 154.30 6.67 7.80 77.51 103.20 117.76 6.37 7.02 92.43 105.20 165.61 8.03 5.28 45.62 115.39 206.44 10.12 7.10 84.24 120.68 143.77 6.32 7.69 95.52 123.09 120.66 7.30 5.61 33.33 123.42 190.78 7.59 7.10 36.68 126.03 148.42 7.09 7.03 67.40 127.70 178.54 7.73 7.80 83.06 128.41 180.38 4.80 7.51 30.66 130.90 123.20 6.78 6.25 92.35 137.41 208.30 8.29 5.82 106.61 139.48 141.44 6.70 7.03 106.29 140.72 176.17 5.71 7.36 39.91 141.12 158.39 6.44 5.06 43.00 141.14 232.18 7.01 5.28 30.03 141.77 166.08 8.36 7.59 15.13 144.13 157.28 5.64 5.55 78.07 146.82 234.65 6.47 8.28 59.59 147.67 131.64 7.30 5.74 42.71 149.94 133.86 7.47 7.62 75.35 151.11 180.82 5.89 5.55 83.66 151.23 153.44 6.81 7.73 54.95 152.29 190.96 8.45 6.24 128.85 154.93 199.96 5.91 4.69 79.15 158.53 201.08 6.19 5.63 64.26 159.52 122.21 6.46 5.94 29.62 162.03 210.77 6.80 4.91 127.21 162.93 221.32 7.21 5.64 81.90 169.41 151.59 6.92 4.23 106.07 175.33 194.86 7.37 5.00 24.14 175.54 210.96 7.40 5.91 43.10 177.02 184.02 8.63 6.04 111.80 180.28 190.29 6.97 4.50 47.59 184.58 188.87 5.96 5.88 30.34 185.51 169.29 6.11 5.93 81.56 185.57 210.91 6.95 4.77 64.55 186.25 160.57 6.62 5.01 39.29 188.03 141.25 6.70 7.99 77.72 189.17 141.97 7.42 5.54 104.35 189.45 172.99 6.45 6.62 78.55 190.23 162.16 8.62 6.02 46.80 192.09 202.68 6.67 6.47 73.17 195.66 149.87 7.25 5.96 29.80 195.90 177.38 9.11 6.03 109.49 197.03 172.47 5.29 6.45 101.23 200.76 108.00 6.27 5.78 78.39 202.77 219.42 7.37 5.19 98.41 202.89 190.78 6.67 6.25 8.61 204.37 162.31 8.69 6.89 67.22 206.14 145.40 6.12 6.30 48.08 207.03 209.81 6.41 6.72 47.50 207.59 211.37 7.95 6.69 32.80 1 2 2 1 2 2 2 1 2 1 2 1 45 55 51 49 58 53 42 53 72 47 52 56 5.72 5.72 5.57 5.33 5.74 6.01 6.05 5.42 5.35 5.50 5.80 5.77 207.74 207.94 211.34 213.61 216.90 219.37 226.33 229.00 232.82 234.91 249.76 250.29 144.36 172.53 166.27 163.01 168.54 180.14 114.56 138.20 173.77 164.41 137.17 132.01 7.09 7.50 5.44 5.89 7.29 6.23 5.47 5.99 7.89 7.72 7.17 7.32 6.69 7.42 6.33 7.21 7.02 6.04 6.46 6.35 5.02 5.30 6.12 5.45 61.21 68.82 39.08 37.47 71.46 113.72 83.02 99.30 36.93 30.89 22.48 141.40 Total Fat Intake 2 Dietary Chol intake 1 Dietary Chol intake 2 % CalfrFat 1 53.22 232.70 217.90 33.97 243.29 124.07 30.68 326.33 213.57 44.71 154.21 163.64 68.44 338.76 110.54 36.01 62.66 131.17 71.62 170.49 171.04 44.20 -5.91 4.37 25.01 349.75 123.75 58.91 223.81 137.14 85.00 233.84 218.86 2.18 596.02 96.20 41.53 615.87 32.31 62.92 317.16 191.34 31.88 239.63 174.15 31.14 338.57 181.17 39.96 349.97 171.60 43.24 213.62 115.39 68.34 86.16 246.24 73.91 732.80 242.78 36.39 160.93 134.43 27.48 36.45 265.31 29.90 388.85 -50.61 -11.05 136.51 347.42 29.99 74.90 324.51 33.12 191.00 302.56 71.27 116.25 298.73 24.18 88.60 263.77 53.44 388.74 83.10 35.75 153.69 166.95 33.21 198.43 313.37 27.98 -16.76 -98.55 78.59 260.83 1.96 53.15 231.96 134.25 48.13 159.30 -13.31 35.45 194.64 395.50 45.07 397.75 50.23 19.80 201.35 446.84 34.68 215.44 164.64 43.97 -231.35 228.56 50.21 257.57 117.01 37.40 351.51 249.29 5.93 526.01 106.39 30.97 121.88 125.81 57.16 297.48 273.91 45.65 286.59 133.05 30.98 77.78 188.54 67.77 114.57 361.34 37.95 431.08 116.78 -9.31 310.06 401.21 22.82 323.05 260.04 42.17 192.40 172.23 20.28 17.45 233.22 10.13 -133.31 348.32 % CalfrFat 2 25.24 43.62 39.63 50.63 41.40 27.82 34.40 34.15 23.89 43.90 37.15 37.26 28.68 38.91 33.56 38.65 38.01 32.98 34.06 41.19 43.64 32.55 25.16 22.06 29.68 37.95 34.14 38.39 34.49 41.02 37.39 31.24 39.74 34.29 28.12 41.02 25.97 38.20 36.80 45.13 35.13 35.31 37.79 22.91 38.25 41.07 41.53 42.20 28.22 32.82 14.37 40.25 43.50 48.13 34.96 29.57 26.83 28.44 37.84 16.57 30.11 31.75 32.34 41.43 28.10 25.45 38.63 24.26 20.40 31.88 34.66 27.26 34.19 26.58 12.98 30.57 27.64 35.53 46.70 30.56 22.02 23.93 41.73 36.32 30.40 21.97 28.13 28.23 33.05 26.58 28.91 43.55 22.45 26.15 18.64 27.49 23.24 32.38 22.83 35.97 24.81 45.23 34.34 36.20 33.23 16.38 24.38 43.49 39.47 35.39 50.95 50.68 49.99 68.67 83.97 -5.90 41.97 43.77 39.16 48.71 282.43 339.04 347.39 125.05 224.88 428.57 582.25 124.48 577.17 250.49 612.17 208.93 68.36 -7.08 277.28 128.19 200.41 200.92 388.13 112.03 238.28 181.73 -88.44 277.69 37.02 41.65 23.55 27.71 37.49 37.99 30.02 41.64 28.82 26.34 26.76 35.73 27.59 42.46 26.67 28.89 28.99 34.53 29.50 16.35 22.13 40.97 22.90 38.96 The case will cover inferential techniques from Chapters 12 through 17 & 19 (and all appropriate appendices). You will be required to conduct some descriptive statistics, so this is essentially a comprehensive case! This is most similar to Case 2 in design. It is a case writeup and I give you a specific outline of what you must include. Be sure to follow it carefully. You will be expected to check required conditions, but, unlike case 2, if you do not meet the required conditions, you will be expected to conduct the appropriate nonparametric test. It is your decision about the required conditions based on your included analysis (no right or wrong on that). You may need XLStat or some other software like Minitab to conduct the nonparametric tests. There is a 2 week free trial of the full version of XLStat. Minitab offers a 30 day free trial. Please reach out if you have any issues so we can figure something out. There will be a downloadable Word document with complete instructions and a data file. Do Not submit an Excel file. This should be completed entirely as a single Word document with Excel output inserted according to instructions. You will have as much time as you like to complete it. Be sure to Carefully read all instructions. Don't miss the second page! Important! The data file has multiple variables, but you will each only do TWO of them that I will be individually assigning to you. Analysis of Variance Case Grading Rubric Introduction (5 points possible) Weak Case Analysis Basic summary of case story ONLY or pastes in verbatim from assignment (1-2 points) Analysis Process Analysis Wrong analysis chosen justification and/or no discussion. (10 points (1-4 points) possible) Numerical descriptive statistics and outlier analysis (5 points possible) Includes only either descriptive or outlier discussion. Reports facts with no discussion. (1-2 points) Alpha justification (10 points possible) Not included or does not justify in context of the case; justification indicates poor understanding. (1-4 points) Required Conditions analysis (10 points possible) Not included or facts presented with no analysis; errors in execution indicate poor understanding. (1-4 points) Average Case Analysis Missing aspects shown for excellent. (3-4 points) Exemplary Case Analysis Brief overview of case story, analysis conducted, findings, and statement of paper organization. (5 points) Correct analysis chosen, but justification does not clearly indicate understanding of why this is the correct choice. (5-7 points) Correct analysis chosen; justification clearly indicates understanding of chosen technique; If independent vs blocked, clearly explains why; If factorial, clearly explains factors and levels. (8-10 points) Includes proper summary tables and brief discussion of numerical statistics for both central tendency and variability measures; Tables are organized appropriately for chosen analysis and organized to facilitate comparison; Includes outlier analysis with box plots and discussion for all variables organized correctly for chosen analysis.(5 points) Defends alpha clearly in context of case; justification clearly indicates understanding of type I and type II errors; Explains error types in context of case; Includes consequences of possible decisions made based on results for both error types. (8-10 points) Cleary discussed and analyzed all required conditions for chosen analysis, with no errors in execution. (8-10 pts) Includes summary tables of only relevant stats that were discussed, but organization is not correct for chosen analysis or does not clearly facilitate comparison; Includes only either central tendency or variability; Does not include outlier analysis for all variables; Does not use boxplots, but alternative method is appropriate. (3-4 points) Weak justification of alpha; does not clearly indicate understanding of type I and type II errors; Does not include consequences of possible decisions made based on results for both error types. (5-7 points) Basics included with weak discussion; histograms not organized appropriately for chosen analysis; missing hypotheses or hypotheses not written with correct symbols for Bartlett’s test; no p-values for Bartlett’s test; Bartlett’s conclusion stated correctly (not taken from output); minor errors in execution. (5-7 points) Score/comments Research Hypothesis Analysis (10 points possible) Hypotheses not stated clearly; errors in execution indicate poor understanding. (1-4 points) Minor errors in execution; missing hypotheses; hypotheses not written with correct symbols. (5-7 points) Discussion and Conclusion (5 points possible) Basic summary of paper; no discussion of findings (1-2 points) Basic summary and discussion of findings (3-4 points) Disjointed writing and arguments; appears to be written by different people and just pasted together; No section headings; improper use of appendices. (1-2 points) Poorly written to an extent that clarity is impacted. (1-2 points) Somewhat cohesive presentation, but not fully integrated; Unclear section headings; If appendix is included, it is not used properly (3-4 points) Cohesive, professional presentation; Descriptive section headings; If appendix is included, it is used properly. (5 points) Well written, but some minor grammatical, punctuation, or spelling issues that impact clarity; Mostly logical flow. (3-4 points) Used appropriate statistical concepts and terminology but some concern about conceptual understanding. (5-7 points) Very well written with few grammatical, punctuation, or spelling issues; Paper flows logically. (5 points) Overall Case Cohesiveness and paper organization (5 points possible) Clarity of written communication (5 points possible) Use of statistical concepts (10 points possible) Did not use correct statistical concepts and terminology. Concern about conceptual understanding in many areas. (1-4 points) Clearly stated hypotheses with correct symbols; included appropriate pvalues and correct conclusion. (8-10 points) Clear and thorough discussion of implications of findings; includes suggestions for improvement or further study. (5 points) Use of statistical concepts and terminology clearly indicates conceptual understanding. (8-10 points) Rev. Fall 2020 Regression Case Grading Rubric Weak Case Analysis Introduction (5 points possible) Basic summary of case story or pastes in verbatim from assignment. (1-2 points) Regression Process Scatter plots Included scatterplots, but (10 points no assessment or possible) discussion; Errors in execution indicate poor understanding (1-4 points) Average Case Analysis Exemplary Case Analysis Missing aspects shown for excellent. (3-4 points) Brief overview of market model, analysis conducted, findings, and statement of paper organization. (5 points) Did not assess for both linear relationship and outliers; Weak explanation that does not clearly indicate understanding; minor errors in execution; Poor titles and labels. (5-7 points) Scatterplots correctly prepared with clear titles and labels. Assessed for both linear relationship and outliers; thorough explanation that clearly indicates understanding and what the analyst looks for in assessment. (8-10 points) Correctly pulled from regression output and written with variable names. (5 points) Correct execution of all 3 required conditions checks and outlier check; All graphs have clear titles and labels; Thorough explanation of all 4 components that clearly indicates understanding of each concept and what the analyst looks for in making the determination. (8-10 points) Correct execution of all 3 components; Summary tables of relevant numerical statistics with clear titles and labels; Thorough explanation of all 3 components that clearly indicates understanding of each concept and what the analyst looks for in making the determination. (8-10 points) Correct interpretation of beta, including both the statistical interpretation and what information it Regression Equation (5 points possible) Not included. (1-2 points) Incorrectly written; Did not use variable names. (3-4 points) Residual Analysis (10 points possible) Did not include all 4 components and/or included with no discussion; Errors in execution indicate poor understanding. (1-4 points) Did not assess all 4 components; Weak explanation that does not clearly indicate understanding; Minor errors in execution; Poor titles and labels. (5-7 points) Model Assessment (10 points possible) Did not include all 3 components and/or included with no discussion; Errors in execution indicate poor understanding. (1-4 points) Did not assess all 3 components; Weak explanation that does not clearly indicate understanding; Minor errors in execution; Poor titles and labels. (5-7 points) Beta (5 points possible) No interpretation or major errors in interpretations. (1-2 points) Does not include both the statistical interpretation of beta and what information it gives about Score/comments R2 (5 points possible) No interpretation or major errors in interpretations. (1-2 points) Discussion and Conclusion (5 points possible) Basic summary of paper; no discussion of findings. No discussion of findings relevant to the market model. (1-2 points) Overall Case Cohesiveness and paper organization (5 points possible) Clarity of written communication (5 points possible) Use of statistical concepts (10 points possible) Disjointed writing and arguments; appears to be written by different people and just pasted together; No section headings; improper use of appendices. (1-2 points) Poorly written to an extent that clarity is impacted. (1-2 points) Did not use correct statistical concepts and terminology; Concern about conceptual understanding in many areas. (1-4 points) the market model or errors in interpretation. (3-4 points) Does not include both the statistical interpretation of R2 and what information it gives about the market model or errors in interpretation. (3-4 points) Basic summary and discussion of findings; No summary table or table missing some key relevant statistics; Does not include both discussions required for excellent. (3-4 points) gives about the market model. (5 points) Correct interpretation of R2, including both the statistical interpretation and what information it gives about the market model. (5 points) Somewhat cohesive presentation, but not fully integrated; Unclear section headings; If appendix is included, it is not used properly (3-4 points) Cohesive, professional presentation; Descriptive section headings; If appendix is included, it is used properly. (5 points) Well written, but some minor grammatical, punctuation, or spelling issues that impact clarity; Mostly logical flow. (3-4 points) Used appropriate statistical concepts and terminology but some concern about conceptual understanding. (5-7 points) Very well written with few grammatical, punctuation, or spelling issues; Paper flows logically. (5 points) Summary of findings including summary table of relevant statistics and clear explanation relevant to the market model; Includes discussion of which stocks are most and least sensitive to changes in the index; Includes which stocks would benefit from diversification. (5 points) Use of statistical concepts and terminology clearly indicates conceptual understanding. (8-10 points) Rev. Fall 2020

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Related Questions