Please answer this questions asap please Question 4: Using Excel, conduct a NHST to determine whether there is a correlation in the population. Use a0.05 significance level. Use the Excel file: Assignment8_Spring22.xlsxa. Test Set-Up: What type of Null Hypothesis Test should you use? Is this a left-tailed, two-tailed,or right-tailed test? Place an “X" in the appropriate box:Left-TailTwo-TailRight-TailThis is a t-test to determine whether there is a correlation in the population. Here is the formulafor the Test Statistic:ryn-2t=V1-r?b. What is/are the critical value(s) for t? Degrees of freedom equals n - 2. Use a 5% significancelevel.How many critical values are there? Place an "X" in the appropriate box:OneTwoWhat is (are) the critical value(s)? Round off your answer to three digits passed the decimalpoint. Enter the value or values in this box:Write the Null & Alternate Hypotheses (Follow the examples shown in Clear-Sighted Statistics.Use the appropriate Greek letters and mathematical symbols).Но:с.H1:Here are the Greek Letters and mathematical symbols. Copy and paste the correct symbols.Mathematical SymbolsGreek LettersΣV 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 ofPopularVote*COVIDStateDeathAlabamaAlaskaArizonaArkansasCaliforniaColorado33062.0%12152.8%30828849.0%62.4%18934.3%The data are on the right. The data are located in Assignment8_Spring22.xlsx.16241.9%ConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaii25039.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.1705.4%28751.2%28849.2%7334.3%221IdaholinoisIndiana63.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%lowaKansasKentuckyLouisianaMaineMarylandMassachusetts23623056.1%24762.1%31958.5%9944.0%Type of power analysis: A priori: Compute required sample size.Tails: Two32.1%32.1%186282MichiganMinnesota25847.8%Effect size |pl: 0.40a err prob: 0.05Power (1-ß prob): 0.817234645.3%MississippiMissouriMontanaNebraskaNevadaNew HampshireNew Jersey57.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 tofour digits passed the decimal point.New Mexico25743.5%New YorkNorth CarolinaNorth DakotaOhioOklahoma29637.7%17949.9%25565.1%22753.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%OregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeТехasUtahVermont12440.4%26348.8%27738.6%27755.1%YesNo26661.8%25360.7%25552.1%11158.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%VirginiaWashingtonWest VirginiaWisconsinWyoming17344.0%12338.8%27668.6%17348.8%24769.9%Effect: MediumEffect Size: 0.1615Significance level (a): 0.05Predictors (p): 1Effect Type: R²/n²

Question

Please answer this questions asap please Question 4: Using Excel, conduct a NHST to determine whether there is a correlation in the population. Use a0.05 significance level. Use the Excel file: Assignment8_Spring22.xlsxa. Test Set-Up: What type of Null Hypothesis Test should you use? Is this a left-tailed, two-tailed,or right-tailed test? Place an “X&#34; in the appropriate box:Left-TailTwo-TailRight-TailThis is a t-test to determine whether there is a correlation in the population. Here is the formulafor the Test Statistic:ryn-2t=V1-r?b. What is/are the critical value(s) for t? Degrees of freedom equals n - 2. Use a 5% significancelevel.How many critical values are there? Place an &#34;X&#34; in the appropriate box:OneTwoWhat is (are) the critical value(s)? Round off your answer to three digits passed the decimalpoint. Enter the value or values in this box:Write the Null & Alternate Hypotheses (Follow the examples shown in Clear-Sighted Statistics.Use the appropriate Greek letters and mathematical symbols).Но:с.H1:Here are the Greek Letters and mathematical symbols. Copy and paste the correct symbols.Mathematical Symbols>Greek LettersΣV 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 ofPopularVote*COVIDStateDeathAlabamaAlaskaArizonaArkansasCaliforniaColorado33062.0%12152.8%30828849.0%62.4%18934.3%The data are on the right. The data are located in Assignment8_Spring22.xlsx.16241.9%ConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaii25039.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.1705.4%28751.2%28849.2%7334.3%221IdaholinoisIndiana63.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%lowaKansasKentuckyLouisianaMaineMarylandMassachusetts23623056.1%24762.1%31958.5%9944.0%Type of power analysis: A priori: Compute required sample size.Tails: Two32.1%32.1%186282MichiganMinnesota25847.8%Effect size |pl: 0.40a err prob: 0.05Power (1-ß prob): 0.817234645.3%MississippiMissouriMontanaNebraskaNevadaNew HampshireNew Jersey57.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 tofour digits passed the decimal point.New Mexico25743.5%New YorkNorth CarolinaNorth DakotaOhioOklahoma29637.7%17949.9%25565.1%22753.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&#34; in theappropriate box:30265.4%OregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeТехasUtahVermont12440.4%26348.8%27738.6%27755.1%YesNo26661.8%25360.7%25552.1%11158.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%VirginiaWashingtonWest VirginiaWisconsinWyoming17344.0%12338.8%27668.6%17348.8%24769.9%Effect: MediumEffect Size: 0.1615Significance level (a): 0.05Predictors (p): 1Effect Type: R²/n²

Accepted Answer

Given Information:
Independent variable X is Trump's share of popular vote
Dependent variable Y is…