create a Microsoft Excel spreadsheet with the two variables from the learning team's dataset.

I am working on Alg2 polynomial Functions an I have this study guide that I need help with so that I can understand how to do the computations for my test. Can you please show your work on each questions, thank you in advance for great help.

APA FORMAT ACTIVE VOICE TIMES ROMAN 12 FREE OF GRAMMATICAL SPELLING SENTENCE STRUCTURE ERRORS FIRM GRASP OF ENGLISH LANGUAGE ZERO USE OF CONVERSATIONAL ENGLISH IN TEXT CITATIONS REFERENCE PAGE Grading Rubric A=4=Mastery For credit for these assignments, you must submit an Excel Workbook showing your calculations (must also include cell references) in addition to a Word Document in which you answer the questions and enter the values from your Excel Workbook. A 4 Mastery All problems are solved correctly. Complete and detailed steps are provided to explain how to solve the problem. Explanations demonstrate a mastery of understanding of the statistical concepts and terminology. All variables, equations, and expressions are properly formatted. CompetencyFormulate and evaluate hypothesis tests for population parameters based on sample statistics using both Critical Regions and P-Values, and be able to state results in a non-technical way that can be understood by consumers of the data instead of statisticians.Student ProfileYou are a statistician working for a drug company. A few new scientists have been hired by your company. They are experts in pharmacology, but are not experts in doing statistical studies, so you will explain to them how statistical studies are done when testing two samples for the effectiveness of a new drug. The two samples can be dependent or independent, and you will explain the difference.Concept being StudiedYour focus is on hypothesis tests and confidence intervals for two populations using two samples, some of which are independent and some of which are dependent. These concepts are an extension of hypothesis testing and confidence intervals which use statistics from one sample to make conclusions about population parameters.What to SubmitYour research and analysis should be presented on the Word document provided. All calculations should be provided on a separate Excel workbook that should be submitted to your boss as well.