using Excel A previous researcher has published a report demonstrating that students' interest in studying mathematics is related to his or her interest in general academics. Furthermore, this researcher also claimed that interest in studying English-related subjects (literature, journalism, etc.) was not related to interest in mathematics. However, after reading the article, you believe the findings contradict your experience, and you believe there was a methodological flaw in the analysis. Inparticular, you believe it was necessary for the researcher to have accounted for another variable: school year.Your plan is to collect a small data set from 2 groups of students. Your research questions are based around the hypothesis that the relationship between interest in mathematics and interest in both academics & English subjects ismoderated by school year.Using the same measurement scales for interest as the first researcher, you collect data from two groups. The first group is all year-8 students. The second group is all year-10 students. You will now run a multiple regression analysis usingthe interest in general academics and English classes as the independent variables and interest in mathematics as the dependent variable. For this analysis, you should use a significance level of a0.02.Interest inInterest inInterest inInterest inInterest inInterest inGeneralStudyingMathematicsGeneralEnglishEnglishClassesStudyingMathematicsAcademicsClassesAcademics68.145.246.468.752.555.652.438.244.462.745.762.863.260.74857.540.955.752.248.354.453.746.962.848.856.354.272.243.556.35342.746.974.652.45355.760.943.650.343.55559.563.747.157.151.543.2GROUP-1GROUP-25044.834.660.753.951.3Year-8 Students Year-10 Students69.962.848.567.846.863.151.940.633.457.755.553.353.35852.646.761.342.153.35347.770.347.156.656.347.842.757.432.861.270.162.751.968.453.757.148.549.944.668.540.852.245.267.254.156.652.560.660.138.437.777.840.272.361.565.263.754.254.646.455.457.253.372.647.862 (1a) When examining the first group (year-B), what is the estimated value for the influence (slepe of interest in general academics when predicting interest in mathematics ivfen rurvning the regression include both interest in English ciasses andinterest in general academics as the indeperndert variables?(Report answer accurate to 3 decimal places.)( 1b) What is the p-value for this slope?(Report answer accurate to 4edecimal places.)( 1c) Using the results from part 1b, is the influence of interest in general academics on interest in mathematics statistically significantly different from zero?OyesOno( 2a) Using the same regression output as above, what is the estimated value for the influence slopel af interest in English classes when predicting interest in mathematics?(Report answer accurate to 3 decimal places.)( 2b) What is the p-value for this slope?(Report answer accurate to 4 decimal places.)(2c) Using the results from part 2b, is the influence of interest in English classes on interest in mathematics statistically significantly different fram zero?OyesOno( 3a) When examining the second group (year-10), what is the estimated value for the influence (slopel of interest in general academics when predicting interest in mathematics (when running the regression include both interest in English classesand interest in general acadermics as the independent variatles?(Report answer accurate to 3 decimal places.)( 3b) What is the p value for this slope?(Report answer accurate to 4 decimal places.)( 3c) Using the results from part 30, is the influence of interest in general academics on interest in mathematics statistically significanly different from zero?OyesOno( 4a) Using the same regression output as above, what is the estimated value for the influence slopel af interest in Engish classes when predicting interest in mathematics?(Report answer accurate to 3 decimal places.)( 4b) What is the p value for this slope?(Report answer accurate to 4 decimal places.)( 4c) Using the results from part 4b, is the influence of interest in English classes on interest in mathematics statistically significantly different from zero?OyesOno

Name: using Excel A previous researcher has published a report demonstrating
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: using Excel A previous researcher has published a report demonstrating that students' interest in studying mathematics is related to his or her interest in general academics. Furthermore, this researcher also claimed that interest in studying English

Note: Hey there! Thank you for the question. As you have posted several sub-parts of a question, according to our policy, we have solved the first three sub-parts for you. If you need help with the other sub-parts, please re-post them separately.1a. First, we have entered the data on Group 1 as follows: Go to Data, select Data Analysis and choose Regression. In Input Y Range, select $C$1:$C$21. In Input X Range, select $A$1:$B$21. Select Labels, and enter Confidence Level as 98 [since significance level is 0.02, confidence level is 1 - 0.02 = 0.98 or 98%]. Click OK. The following output is obtained: From the output, the coefficient for "Interest in General Academics" is –0.039 (rounded to three decimal places, from the column of "Coefficients" corresponding the row of "Interest in General Academics"). Thus, the required value is –0.039.1b. From the output, the p-value for "Interest in General Academics" is 0.839 (rounded to three decimal places, from the column of "P-value" corresponding the row of "Interest in General Academics"). Thus, the required value is 0.839.1c. Denote β1 as the true partial slope of Interest in General Academics. The influence of Interest in General Academics on Interest in Mathematics will be significant if β1 is significantly different from 0. The null and alternative hypotheses for the test are: H0: β1 = 0. H1: β1 ≠ 0. Here, the significance level is, α = 0.02. Decision rule: If p-value ≤ α, the regression coefficient is significant. Otherwise, the regression coefficient is not significant. Since p-value (≈ 0.839) > α (= 0.02), fail to reject H0. Thus, the influence of Interest in General Academics on Interest in Mathematics is not significantly different from 0.

Math

Statistics

( 1a) When examining the firsa group (ynar what is the esimated value for the influence ogeol intres in general academics when gredicing irterest in mathematics faten running the regression include both interest in Erglish classes and interest in general academics as the independert variobles? Report anwer accurate to 3 decimal places) ( 1b) Whatis the pvalue for this slope? (Report answer accurate to 4 decimal places) (1c) Using the resits from part 1, is the influence of interesa in general academics on incerest in mathematics satistically signilicantly different from zero? Oyes Ono