I will provide the required data in a seperate setDeath 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-19 seems particularly strong in states that Donald Trump won in the 2020 presidential election. They wondered whether there is a correlation between the COVID-19 death rate per 100,000 people per state and Donald Trump’s share of the popular vote in 2020 per the 50 states and District of Columbia. The death rate data was sorted from a Johns Hopkins University/CNN report. The Voting data was sourced from CNN.Question 1: A Priori Statistical PowerBefore collecting the data, they decided to calculate a priori statistical power to determine how large a sample is needed to achieve 80% statistical power. G*PowerConduct an a priori power analysis using G*Power. (If you are not using a Windows or Macintosh computer use Statistics Kingdom to estimate sample size) Here are the setting for G*Power:Test family: t testsStatistical test: Correlation: Point biserial modelType of power analysis: A priori: Compute required sample size….Tails: TwoEffect size |ρ|: 0.40α err prob: 0.05Power (1-β prob): 0.8a. What is the required sample size?b. What level of statistical power will be achieved? Round off your answer to four digits passed the decimal point.Using data from 50 states and the District of Columbia, do they have a sufficiently large sample size to achieve 80% power assuming that the coefficient of correlation is the population equal 0.40? Please an “X” in the appropriate box:YesNo Statistics KingdomIf you are using a Chromebook, conduct an a priori power analysis using the tool found at https://www.statskingdom.com/sample_size_regression.html.Here are the settings:Type: RegressionPower: 0.8Effect: MediumEffect Size: 0.1615Significance level (α): 0.05Predictors (p): 1Effect Type: R2/η2Digits: 4 What is the required sample size to achieve 80 percent statistical power? What level of statistical power will be achieved? Round off your answer to four digits passed the decimal point. Using data from 50 states and the District of Columbia, do they have a sufficiently large sample size to achieve 80% power assuming that the coefficient of correlation is the population equal 0.40? Please an “X” in the appropriate box:YesNo Question 2: You have two variables: 1) Death rate by state and 2) Percent of popular vote won by Donald Trump by state. Which is the independent variable and which is the dependent variable? Enter your answer in the table below:VariableIndependent or Dependent?Death Rate by State Popular Vote Won By Trump explain your answerQuestion 3: Using Microsoft Excel: (Excel file Assignment10.xlsx)Calculate the mean and sample standard deviation of both the independent and dependent variables.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. a very high score. Report your results here:Paste your Excel table here using Word’s Paste Special function. 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 Correlation Coefficient of determination means: Question 4: Using Excel, conduct a NHST to determine whether there is a correlation in the population. Use a 0.05 significance level. Use the Excel file: Assignment8_Spring22.xlsxTest 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-Tail Two-Tail Right-Tail This is a t-test to determine whether there is a correlation in the population. Here is the formula for the Test Statistic: What is/are the critical value(s) for t? Degrees of freedom equals n – 2. Use a 5% significance level. How many critical values are there? Place an “X” in the appropriate box:OneTwo What is (are) the critical value(s)? Round off your answer to three digits passed the decimal point. 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).H0: H1: Here are the Greek Letters and mathematical symbols. Copy and paste the correct symbols.Mathematical Symbols=≤≥≠ I

Question

I will provide the required data in a seperate setDeath 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-19 seems particularly strong in states that Donald Trump won in the 2020 presidential election. They wondered whether there is a correlation between the COVID-19 death rate per 100,000 people per state and Donald Trump’s share of the popular vote in 2020 per the 50 states and District of Columbia. The death rate data was sorted from a Johns Hopkins University/CNN report. The Voting data was sourced from CNN.Question 1: A Priori Statistical PowerBefore collecting the data, they decided to calculate a priori statistical power to determine how large a sample is needed to achieve 80% statistical power. G*PowerConduct an a priori power analysis using G*Power. (If you are not using a Windows or Macintosh computer use Statistics Kingdom to estimate sample size) Here are the setting for G*Power:Test family: t testsStatistical test: Correlation: Point biserial modelType of power analysis: A priori: Compute required sample size….Tails: TwoEffect size |ρ|: 0.40α err prob: 0.05Power (1-β prob): 0.8a. What is the required sample size?b. What level of statistical power will be achieved? Round off your answer to four digits passed the decimal point.Using data from 50 states and the District of Columbia, do they have a sufficiently large sample size to achieve 80% power assuming that the coefficient of correlation is the population equal 0.40? Please an “X” in the appropriate box:YesNo  Statistics KingdomIf you are using a Chromebook, conduct an a priori power analysis using the tool found at https://www.statskingdom.com/sample_size_regression.html.Here are the settings:Type: RegressionPower: 0.8Effect: MediumEffect Size: 0.1615Significance level (α): 0.05Predictors (p): 1Effect Type: R2/η2Digits: 4 What is the required sample size to achieve 80 percent statistical power?  What level of statistical power will be achieved? Round off your answer to four digits passed the decimal point.  Using data from 50 states and the District of Columbia, do they have a sufficiently large sample size to achieve 80% power assuming that the coefficient of correlation is the population equal 0.40? Please an “X” in the appropriate box:YesNo   Question 2: You have two variables: 1) Death rate by state and 2) Percent of popular vote won by Donald Trump by state. Which is the independent variable and which is the dependent variable? Enter your answer in the table below:VariableIndependent or Dependent?Death Rate by State Popular Vote Won By Trump explain your answerQuestion 3: Using Microsoft Excel: (Excel file Assignment10.xlsx)Calculate the mean and sample standard deviation of both the independent and dependent variables.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. a very high score. Report your results here:Paste your Excel table here using Word’s Paste Special function.   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 Correlation Coefficient of determination means:  Question 4: Using Excel, conduct a NHST to determine whether there is a correlation in the population. Use a 0.05 significance level. Use the Excel file: Assignment8_Spring22.xlsxTest 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-Tail Two-Tail Right-Tail  This is a t-test to determine whether there is a correlation in the population. Here is the formula for the Test Statistic:  What is/are the critical value(s) for t? Degrees of freedom equals n – 2. Use a 5% significance level.                How many critical values are there? Place an “X” in the appropriate box:OneTwo                     What is (are) the critical value(s)? Round off your answer to three digits passed the decimal point. 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).H0: H1: Here are the Greek Letters and mathematical symbols. Copy and paste the correct symbols.Mathematical Symbols=≤≥≠> < Greek LettersμπσρΣν Model your answer on the examples shown in Clear-Sighted Statistics. Write the Decision Rule using the Critical Value(s), not p-values. Model your answer on the examples shown in Clear-Sighted Statistics. Failure to do so will result in a major reduction of your grade. Critical Value(s): Decision Rule: AutoSaveAssignment8_Template - La.P Search (Alt+Q)ffSilver 47FileHomeInsertDrawDesignLayoutReferencesMailingsReviewView HelpP CommentsA ShareO Find -Cambria- 10- A A Aa v A:E v = va- vNormalNormal_Doub Normal_NolnReplacePasteBIU - abX.x A • 2 -- A .DictateEditorA Select vUndoClipboard BFontParagraphEditorStylesAlabamaAlaskaArizonaEditingVoice33062.0%seems particularly strong in states that Donald Trump won in the 2020presidential election. They wondered whether there is a correlation between the12152.8%30849.0%COVID-19 death rate per 100,000 people per state and Donald Trump's share ofthe popular vote in 2020 per the 50 states and District of Columbia. The death ratedata was sorted from a Johns Hopkins University/CNN report. The Voting datawas sourced from CNN.ArkansasCalifornia28862.4%18934.3%41.9%39.2%Colorado162Connecticut250Delaware22439,8%District of Columbia1705.4%FloridaGeorgiaHawaiiIdahoThe data are on the right. The data are located in Assignment8_Spring22.xlsx.28751.2%28849.2%7334.3%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.22163.8%linolsIndiana22840.6%26257.0%lowaKansas23653.1%23056.1%G*PowerKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesota62.1%58.5%247Conduct an a priori power analysis using G*Power. (If you are not using aWindows or Macintosh computer use Statistics Kingdom to estimate sample size)Here are the setting for G*Power:Test family: t tests3199944.0%18632.1%28232.1%25847.8%Statistical test: Correlation: Point biserial model17245.3%Type of power analysis: A priori: Compute required sample size.Tails: TwoMississippiMissouriMontana34657.5%25353.8%Effect size |pl: 0.40а err prob: 0.05Power (1-ß prob): 0.825653.9%NebraskaNevadaNew HampshireNew JerseyNew Mexico16458.2%16147.7%12745.4%32041.3%a. What is the required sample size?25729643,5%New York37.7%North Carolina17949.9%North Dakota25565.1%b. What level of statistical power will be achieved? Round off your answer tofour digits passed the decimal point.Ohio22753.3%Oklahoma30265.4%OregonPennsylvaniaRhode IslandSouth Carolina12440.4%26327727748.8%38.6%Using data from 50 states and the District of Columbia, do they have a55 1%Page 1 of 4Text Predictions: On* Accessibility: InvestigateO Focus879 words+100%65°F4:47 PMNWSunny5/17/2022 AutoSaveAssignment8_Template - La.P Search (Alt+Q)ffSilver 47FileHomeInsertDrawDesignLayoutReferencesMailingsReviewView HelpP CommentsA ShareO Find -Cambria- 10- A A Aa v Aa- vNormalNormal Doub Normal_NoIn -ReplacePasteBIU - abX.x' A • 2• A vDictateEditorA Select vUndoClipboard BFontParagraphStylesEditingVoiceEditorEffect size pl: 0.40a err prob: 0.05Power (1-ß prob): 0.8Montana25653.9%58.2%NebraskaNevadaNew Hampshire16416147.7%12745.4%New Jersey32041.3%a. What is the required sample size?New Mexico25743.5%New York29637.7%North Carolina17949.9%North DakotaOhioOklahoma25565.1%b. What level of statistical power will be achieved? Round off your answer tofour digits passed the decimal point.22753.3%30265.4%OregonPennsylvaniaRhode IslandSouth Carolina12440.4%26348.8%27738.6%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:27755.1%South Dakota26661.8%Tennessee25360.7%Техas25552.1%UtahVermontVirginiaWashingtonWest VirginiaWisconsinWyoming111Yes58.1%30.7%No6617344.0%12338.8%27668.6%Statistics KingdomIf you are using a Chromebook, conduct an a priori power analysis using thetool found at https://www.statskingdom.com/sample size regression.html.Here are the settings:Type: RegressionPower: 0.817348.8%24769.9%Effect: MediumEffect Size: 0.1615Assignment8_Spring22.pdfPage 1 of 4Page 1 of 4* Accessibility: InvestigateD Focus879 wordsText Predictions: On+100%65°F4:47 PMNWSunny5/17/2022> I>

Accepted Answer

Since you have asked multiple questions, we will solve the first question for you. If you want any…

Variable	Independent or Dependent?
Death Rate by State
Popular Vote Won By Trump

Negative	Positive	Meaning
0.00 to -0.099	0.00 to -.099	No Correlation
-0.10 to -0.299	0.10 to 0.299	Small Correlation
-0.30 to -0.499	0.30 to 0.499	Medium Correlation
-0.50 to -1.000	0.50 to 1.000	Large Correlation

Mathematical Symbols
=	≤	≥	≠	>	<
Greek Letters
μ	π	σ	ρ	Σ	ν

Yes	No

Yes	No

Left-Tail
Two-Tail
Right-Tail

One	Two