EXCEL AND POWERPOINT RESEARCH ASSIGNMENT : DATA ANALYSIS PLEASE REFER TO PROMPT

Data Analysis Project 3 For this project you will demonstrate competency in performing inferential statistics by selecting various research topics, collecting sample data, and using fundamental statistical and regression concepts to support your answer s. Carefully f ollow these steps to complete the project: 1. Using the data covered in the National Economy, Wealth Income and Poverty, Business Statistics, Labor Statistics, and Government , generate five research question s to study (one from each category ). Phr ase each question in a causal form such as “Higher taxes cause lower GDP ” or “Increased worker productivity causes increased savings ”. 2. Excel File: A. For three of the five research questions create an Excel sheet with sample data that includes one dependent variable and one inde pendent variables (n >=30) .With the data, generate the following through your own calculations or the app ropriate Excel functions:  Calculate the Mean & Median for your dependent variable.  Sample Standard Deviation .  Margin of Error for your data .  Point Estimate for the true population mean.  95% confidence interval for the true population mean  Hypothesis test (perform one two -tailed, one upper -tailed, and one lower -tailed test overall ) and include the following: o Null and Alternative Hypothesis o Level of significance for a 95% confidence interval. o Critical T o Computed T o Decision Rule B. SINGLE -VARIABLE REGRESSION: For one of the five research questions create an Excel sheet with sample data that includes one dependent variable and one inde pendent variable (n>=30) . Using this data, generate the following :  One scatt erplot graph with R-squared and trend line . U se the functional form with the highest R -squared.  Single -variable regression output using Excel ’s Data Analysis Tool . C. MULTIPLE -VARIABLE REGRESSION: For one of the five research questions create an Excel sheet with sample data that includes one dependent variable and at least five inde pendent variables (n >=30) .Keep in mind that each of your independent variables must be believed to influence the dependent variable. This means you are actually studying how each one causes changes in your dependent variable. With the data, generate the following :  Multiple -variable regression output using Excel ’s Data Analysis Tool . 3. PowerPoint Presentation : For each research question (five total), create at least one PowerPoint slide illustrating the pertinent graphs, statistical metrics, regression results, bullet points (up to 3 and optional), and hyperlinks to your data source website (make sure the links work). The PowerPoint should also contain an introduction slide (e.g. name, project #, and class). For th e single and multiple regression s add at least on e slide answering each of the following:  What is the regression R -Squared and what does it mean regarding your data?  What are the statistically significant coefficients and how did you conclude they were statistically signifi cant?  What are the statistically insignificant coefficients and how did you conclude the y were insignificant?  Interpret each statistically significant coefficient to determine how your dependent and independent variables are correlated; that is, for a cha nge in each independent variable how does this impact the dependent variable. Make sure you use the proper denominations (e.g. each square foot added to a home increases the home price by $123). If no stati sti cally significant results are found, then you are to do the same thing but indicate that the results cannot be relied upon. 4. Submission: Upload the Excel and PowerPoint file into the link provided in Blackboard by the due date (no e -ma iled copies). 5. Grading: Project grade is weighted 50/50 for Excel/PowerPoint; however, both must be submitted to receive a score. Excel graphs must be derived from the data input in Excel. The PowerPoint is graded subjectively as a presentation to your f ellow classmates so cosmetics, spelling, character size, color, creativity all matter. 6. Academic Integrity: Do not copy graphs from websites nor replicate another student’s work.