Just do question 3 i included all the information you might need thanks Question 3: Using Microsoft Excel: (Excel file Assignment10.xlsx)Calculate the mean and sample standard deviation of both the independent and dependentvariables.а.b. Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means.Calculate the coefficient of determination, r2, using Excel's RSQ function. Explain what it means. avery high score.с.Report your results here:Paste your Excel table here using Word's Paste Special function.d. Coefficient of correlation means:Interpret the coefficient of correlation using this table.NegativePositiveMeaning0.00 to -0.0990.00 to -.099No Correlation-0.10 to -0.2990.10 to 0.299Small Correlation-0.30 to -0.4990.30 to 0.499Medium Correlation-0.50 to -1.0000.50 to 1.000Large Correlatione. Coefficient of determination means:Assignment8 Spring22 ndfPage 4 of6 Death Rate per 100,000 people and Donald Trump's share of the popular vote.A group of political activists noticed that hesitancy to get the vaccine for COVID-19seems particularly strong in states that Donald Trump won in the 2020 presidentialelection. They wondered whether there is a correlation between the COVID-19 deathrate per 100,000 people per state and Donald Trump's share of the popular vote in2020 per the 50 states and District of Columbia. The death rate data was sorted from aJohns Hopkins University/CNN report. The Voting data was sourced from CNN.Trump'sPer Capita Share ofCOVIDPopularVoteStateAlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaDeath33062.0%12152.8%30849.0%28862.4%18934.3%The data are on the right. The data are located in Assignment8_Spring22.xlsx.16241.9%25039.2%22439.8%Question 1: A Priori Statistical PowerBefore collecting the data, they decided to calculate a priori statistical power todetermine how large a sample is needed to achieve 80% statistical power.5.4%51.2%170287288GeorgiaHawaiiIdaholinoisIndiana49.2%7334.3%22163.8%G*Power22840.6%Conduct an a priori power analysis using G*Power. (If you are not using a Windows orMacintosh computer use Statistics Kingdom to estimate sample size) Here are thesetting for G*Power:Test family: t testsStatistical test: Correlation: Point biserial model26257.0%53.1%236230lowa56.1%KansasKentuckyLouisianaMaine24762.1%31958.5%9944.0%Type of power analysis: A priori: Compute required sample size..Tails: TwoMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew Jersey18632.1%28225817232.1%47.8%45.3%Effect size |p|: 0.40a err prob: 0.05Power (1-B prob): 0.834657.5%25353.8%25653.9%a. What is the required sample size?16458.2%16147.7%12745.4%32041.3%b. What level of statistical power will be achieved? Round off your answer toNew MexicoNew YorkNorth CarolinaNorth Dakota25743.5%four digits passed the decimal point.29617937.7%49.9%25565.1%OhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennessee22753.3%Using data from 50 states and the District of Columbia, do they have asufficiently large sample size to achieve 80% power assuming that thecoefficient of correlation is the population equal 0.40? Please an "X" in theappropriate box:30265.4%12440.4%26348.8%27738.6%27755.1%YesNo26661.8%25360.7%Техas25552.1%UtahVermontVirginiaWashingtonWest VirginiaWisconsin11158.1%Statistics KingdomIf you are using a Chromebook, conduct an a priori power analysis using the toolfound at https://www.statskingdom.com/sample size regression.html.Here are the settings:Type: RegressionPower: 0.86630.7%17344.0%12338.8%27617368.6%48.8%Wyoming24769.9%Effect: MediumEffect Size: 0.1615Significance level (a): 0.05Predictors (p): 1Effect Type: R2/n?

Question

Just do question 3 i included all the information you might need thanks Question 3: Using Microsoft Excel: (Excel file Assignment10.xlsx)Calculate the mean and sample standard deviation of both the independent and dependentvariables.а.b. Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means.Calculate the coefficient of determination, r2, using Excel's RSQ function. Explain what it means. avery high score.с.Report your results here:Paste your Excel table here using Word's Paste Special function.d. Coefficient of correlation means:Interpret the coefficient of correlation using this table.NegativePositiveMeaning0.00 to -0.0990.00 to -.099No Correlation-0.10 to -0.2990.10 to 0.299Small Correlation-0.30 to -0.4990.30 to 0.499Medium Correlation-0.50 to -1.0000.50 to 1.000Large Correlatione. Coefficient of determination means:Assignment8 Spring22 ndfPage 4 of6 Death Rate per 100,000 people and Donald Trump's share of the popular vote.A group of political activists noticed that hesitancy to get the vaccine for COVID-19seems particularly strong in states that Donald Trump won in the 2020 presidentialelection. They wondered whether there is a correlation between the COVID-19 deathrate per 100,000 people per state and Donald Trump's share of the popular vote in2020 per the 50 states and District of Columbia. The death rate data was sorted from aJohns Hopkins University/CNN report. The Voting data was sourced from CNN.Trump'sPer Capita Share ofCOVIDPopularVoteStateAlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaDeath33062.0%12152.8%30849.0%28862.4%18934.3%The data are on the right. The data are located in Assignment8_Spring22.xlsx.16241.9%25039.2%22439.8%Question 1: A Priori Statistical PowerBefore collecting the data, they decided to calculate a priori statistical power todetermine how large a sample is needed to achieve 80% statistical power.5.4%51.2%170287288GeorgiaHawaiiIdaholinoisIndiana49.2%7334.3%22163.8%G*Power22840.6%Conduct an a priori power analysis using G*Power. (If you are not using a Windows orMacintosh computer use Statistics Kingdom to estimate sample size) Here are thesetting for G*Power:Test family: t testsStatistical test: Correlation: Point biserial model26257.0%53.1%236230lowa56.1%KansasKentuckyLouisianaMaine24762.1%31958.5%9944.0%Type of power analysis: A priori: Compute required sample size..Tails: TwoMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew Jersey18632.1%28225817232.1%47.8%45.3%Effect size |p|: 0.40a err prob: 0.05Power (1-B prob): 0.834657.5%25353.8%25653.9%a. What is the required sample size?16458.2%16147.7%12745.4%32041.3%b. What level of statistical power will be achieved? Round off your answer toNew MexicoNew YorkNorth CarolinaNorth Dakota25743.5%four digits passed the decimal point.29617937.7%49.9%25565.1%OhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennessee22753.3%Using data from 50 states and the District of Columbia, do they have asufficiently large sample size to achieve 80% power assuming that thecoefficient of correlation is the population equal 0.40? Please an &#34;X&#34; in theappropriate box:30265.4%12440.4%26348.8%27738.6%27755.1%YesNo26661.8%25360.7%Техas25552.1%UtahVermontVirginiaWashingtonWest VirginiaWisconsin11158.1%Statistics KingdomIf you are using a Chromebook, conduct an a priori power analysis using the toolfound at https://www.statskingdom.com/sample size regression.html.Here are the settings:Type: RegressionPower: 0.86630.7%17344.0%12338.8%27617368.6%48.8%Wyoming24769.9%Effect: MediumEffect Size: 0.1615Significance level (a): 0.05Predictors (p): 1Effect Type: R2/n?

Accepted Answer

Given data indicates the death rate per 100,000 people per state and Donald Trump's share of the…