|SOLVED| Assignment Elaborated| MATH-225: Statistical Reasoning for the Health Sciences-Questions and Answers-WK 8 Assignment Multivariate Relationships.

|SOLVED| Assignment Elaborated| MATH-225: Statistical Reasoning for the Health Sciences-Questions and Answers-WK 8 Assignment Multivariate Relationships. MATH 225-WK 8 Assignment Multivariate RelationshipsAn amateur astronomer is researching statistical properties of known stars using a variety of databases. They collect the absolute magnitude or MV and stellar mass or M⊙ for 30 stars. The absolute magnitude of a star is the intensity of light that would be observed from the star at a distance of 10 parsecs from the star. This is measured in terms of a particular band of the light spectrum, indicated by the subscript letter, which in this case is V for the visual light spectrum. The scale is logarithmic and an MV that is 1 less than another comes from a star that is 10 times more luminous than the other. The stellar mass of a star is how many times the sun's mass it has. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets, rounding to two decimal placesA market researcher looked at the quarterly sales revenue for a large e-commerce store and for a large brick-and-mortar retailer over the same period. The researcher recorded the revenue in millions of dollars for 30 quarters. The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.An organization collects information on the life expectancy (in years) of a person in certain countries and the fertility rate per woman in those countries. The data for 21 randomly selected countries for the year 2011 is given below. Use Excel to find the best fit linear regression equation, where fertility rate is the explanatory variable. Round the slope and intercept to two decimal places.An economist is trying to understand whether there is a strong link between CEO pay ratio and corporate revenue. The economist gathered data including the CEO pay ratio and corporate revenue for 30 companies for a particular year. The pay ratio data is reported by the companies and represents the ratio of CEO compensation to the median employee salary. The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal placesA researcher is interested in whether the variation in the size of human beings is proportional throughout each part of the human. To partly answer this question they looked at the correlation between the foot length (in millimeters) and height (in centimeters) of 30 randomly selected adult males. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places