Kindly find the questions below, Excercise 1,2,3,4 Provide an Excel sheet the email is in the attached document. The questions can be answered by word document if possible

the email address is attached for the documents

Test scores of students (out of 10) Class A (constant sound) LD DO 10 4 Class B (variable sound) 4 LU 2 7 5 4 Class C (no sound) 5 7Exercise 1: In many manufacturing processes there is a term called work in process (often abbreviated WIP). In a book manufacturing plant this represents the time it takes for sheets from a press to be folded, gathered, sewn, tipped on end sheets, and bound. The following data represent samples of 19 books at each of two production plants and the processing time (operationally defined as the time in days from when the books came off the press to when they were packed in cartons) for these jobs. Plant A: 5, 16, 10, 11, 22, 8, 9, 7, 11 Plant B: 11, 9, 16, 12, 25, 15, 14, 13, 15, 10 For each of the two plants, (a) Compute the mean, median, range, interquartile range, variance, and the standard deviation. (b) Construct box plots. Are the data skewed? If so, how? ( C ) Based on the results of (a)-(c), describe the distribution of the two plants? (d) Find a 95% confidence interval for the mean of the population these sample are taken from. (e) Do these data provide sufficient evidence to indicate that WIP of Plant A, on average, different than it for Plant B? Use 10% level of significance. Exercise 2: The American Heart Association collects data on the risk of strokes. A 10-year study provided data on how age, blood pressure, and smoking related to the risk of strokes (U.S. News & World Report, April 13, 1992). Assume that following data are from a portion of this study. Risk is interpreted as the probability (times 100 ) that the patient will have a stroke over the next 10-year period. For the smoking variable, define a dummy variable with 1 indicating a smoker and 0 indicting a non-smoker. RISK% AGE BLOOD SMOKER PRESSURE 12 57 152 24 67 163 0 13 58 155 0 56 86 177 1 28 59 196 051 76 189 1 18 56 155 31 78 120 0 37 80 135 1 15 78 98 0 22 71 152 0 36 70 173 1 15 67 135 1 48 77 209 1 15 60 199 0 36 82 119 1 8 66 166 0 34 80 125 1 3 62 117 0 37 59 207 1 a. What are the dependent and independent variables (in words)? Draw the Scatter plot using Microsoft Excel. (5 marks) C. What is the value of the linear correlation coefficient? Use this value to comment on whether you think a linear relationship exists between the dependent and independent variables d. Use Excel outputs to estimate the multiple linear regression equation. e. Interpret each one of the estimated regression coefficients BO, B1, B2, and B3. f. Identify and interpret the coefficient of determination g. Test the significance of the regression model at the 5% level. h. Does each one of the explanatory variables do a good job of explaining changes in the risk of strokes? Explain why or why not. i. Predict the chance of stroke (risk%) for a person of age 57 years, blood pressure of 125 and knowing that he doesn't smoke.Exercise 3: A manufacturer of watches takes a sample of 200 people. Each person is classied by age and watch type preference (digital vs. analog). The question: is there a relationship between age and watch preference? The data (observed frequencies) are presented in a "cross tabulation" of the two variables as follows: Watch preference digital analog undecided Hint: Ho: In the population, preference is independent of (NOT related to) age Ha: In the population, preference is related to age Set a = 0.05 Exercise 4: A recent study claims that using music in a class enhances the concentration and consequently helps students absorb more information. As a teacher, your first reaction would be skepticism. What if it affected the results of the students in a negative way? Or what kind of music would be a good choice for this? Considering all this, it would be immensely helpful to have some proof that it actually works. To figure this out, we decided to implement it on a smaller group of randomly selected students from three different classes. The idea is similar to conducting a survey. We take three different groups of ten randomly selected students (all of the same age) from three different classrooms. Each classroom was provided with a different environment for students to study. Classroom A had constant music being played in the background, classroom B had variable music being played and classroom C was a regular class with no music playing. After one month, we conducted a test for all the three groups and collected their test scores. The test scores that we obtained were as follows: Test scores of students (out of 10 Class A (constant sound 9 5 8 6 8 6 10 4 Class B (variable sound 4 3 6 5 5 4 3 Class C (no sound) 6 3 5 3 4 6 5 7 3Looking at the above table, we might assume that the mean score of students from helpful. Maybe it's true, but there is also a slight chance that we happened to select the best students from class A, which resulted in better test scores (remember, the selection was done at random). This leads to a few questions, like: 1. How do we decide that these three groups performed differently because of the different situations and not merely by chance? 2. In a statistical sense, how different are these three samples from each other? mryoomalbastaki@gmail.com|