What is the MSregression for this problem?Please put the answer in bold. Instructions Download the file "brain_metabolism.xlsx'. It contains data on brain mass in different species versus glia-neuron ratio, thelatter being a measurement of brain metabolism as the glia provides the metabolic needs of the neurons. The relationshipbetween THE LOGARITHM of the brain mass (in the third column) and Glia-neuron ratio (fourth column) appears linear and itis these two variables that we wish to analyze via linear regression. We would like to know if the human brain fits the trendfrom the other species. Towards this end we will perform the regression on all species EXCEPT humans (Homo sapiens).Again, throw out the human data from your analysis. You will however need the human numbers for some of the questions.The analysis to be performed is as follows:1. Calculate the regression line (slope and intercept)2. Perform an ANOVA test of the null hypothesis for zero slope. From this analysis, obtain SStotal, SSregression andSSresidual as well as the corresponding MS statistics.3. Perform a t-test of the null hypothesis of zero slope.4. Compute a 95% confidence interval for the regression slope5. Calculate the predicted glia-neuron ratio for human brain given the human brain mass. Calculate the two confidenceintervals for the predicted glia-neuron ratio corresponding to the mass of the human brain: (i) the confidence interval for thepredicted mean and (ii) the confidence interval for a predicted individual.Once again: You need the human data only for (5) above. Throw it out for the analyses in (1)-(4) AВspeciesIbrainMassInBrainMassgliaNeuronRatioHomo sapiens1373.37.221.65Pan troglodytes336.25.821.2Gorilla gorilla509.26.231.21Pongo pygmaeus342.75.840.98Hylobates muelleri101.84.621.22Papio anubis155.85.050.97Mandrillus sphinx159.25.071.02Macaca maura92.64.530.84Erythrocebus patasCercopithecus kandt102.34.631.0971.64.271.15Colobus angolensisTrachypithecus franAlouatta caraya74.44.311.291.24.511.1455.84.021.12Saimiri boliviensis24.13.180.51Aotus trivirgatus13.22.580.63Saguinus oedipus102.30.46Leontopithecus rosa12.22.50.6Pithecia pithecia303.40.64

Name: What is the MSregression for this problem?Please put the answer in bol
Uploaded: 2024-03-20T07:07:37.000Z
Channel: Bartleby
Description: What is the MSregression for this problem?Please put the answer in bold. Instructions Download the file "brain_metabolism.xlsx'. It contains data on brain mass in different species versus glia-neuron ratio, thelatter being a measurement of brain meta