Mini Group Project 2 8W Fall 2023

.docx

School

University of North Texas *

*We aren’t endorsed by this school

Course

5130

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

10

Uploaded by KidCamel3948

Report
1 Mini-Group Project 2 (8W section Fall’23), Team ____ Instructions: Follow the instructions provided in each task. It is crucial that your responses are clear and written with no grammatical errors as this is a professional setting. Make sure to properly number your answers so that it is easy for the reader to follow your analysis. You can whether use Microsoft Excel or R to complete the homework assignment. Some students are tempted to use Python to complete the work. Since the textbook provides instructions only with R and Excel, you can only use R or Excel to complete the mini-group projects. There are three deliverables: The first two will be submitted on Canvas, the third one should be sent via email. (1) Use the provided MS Word template to enter your work, convert it to pdf, and name it as MGP2_Team_Number  before submitting in Canvas. If you use Excel, you can copy and paste your work (charts/graphs) into this Word template and save as your document in pdf format before submitting in Canvas. If you use R, knit your Quarto document in pdf before submitting in Canvas. (2) Your Excel file (or the Quarto document if R is used) should show your work or codes for each Task.  The Excel file should show the formulas used to derive the results. If you use R, make sure codes run with no error. (3)  Signed statement of team member contribution form.  Each team member of the project group should indicate their contribution to the project showcase and sign the Statement of Contribution Form.  Group project grades will not be released without the signed statement of member contribution form.  Have one group member to send this signed statement to levent.bulut@unt.edu and include each team member and the TA ( srinidhiyadavboda@my.unt.edu )   on the cc. If you have any questions about the mini-group project tasks, use Week 7 discussion forum to post your questions.   Good luck! Team ___ [Enter your Team number in her]
2 Mini-Group Project 2 (8W section Fall’23), Team ____ Data for Tasks 0, 1 and 2: In this project, we will work with two datasets. For Tasks 0, 1 and 2, we will use the Gallup Presidential Approval data for each President starting with Franklin D. Roosevelt. You can access the data from the following link: Presidential Job Approval--All Data | The American Presidency Project (ucsb.edu) . The data in this project is compiled based on responses to the survey question, "Do you approve or disapprove of the way [enter President name] is handling his job as President?" The Excel file contains public approval and disapproval ratings, as well as the proportion of respondents who answered "Don't know" or had no opinion. We will focus on a subset of data covering the last four presidents. The Gallup Job Approval data for the current President, Biden, is stored in the worksheet " Biden " and covers the period from January 21, 2021, to August 23, 2023. The data for President Trump is stored in the worksheet " Trump " and covers the period from January 20, 2017, to January 15, 2021. The data for President Obama is stored in the worksheet " Obama " and covers the period from January 19, 2009, to January 19, 2017. Finally, the data for President George W. Bush is stored in the worksheet " GWBush " and covers the period from February 1, 2001, to January 11, 2009. It's worth noting that the Presidential Job Approval rating data does not have the same frequency of dates for each presidential term. The data for President Biden is available on a monthly basis, while we have weekly data for the others. Data for Tasks 3,4, and 5: For Tasks 3, 4, and 5, we will use “PEW” worksheet. Team ___ [Enter your Team number in her] Data Description
3 Mini-Group Project 2 (8W section Fall’23), Team ____ In each worksheet dedicated to a President, populate the columns named "Approving_adj_[PresidentName]" and "Disapproving_adj_[PresidentName]". Allocate the value from the "Unsure/NoData" column between the "Approving" and "Disapproving" columns in a proportional manner. Ensure that the sum of "Approving_adj_[PresidentName]" and "Disapproving_adj_[PresidentName]" totals 100. Order the Presidents in descending sequence based on the average "Approving_adj" ratings during their initial 1000 days in office along with their average "Approving_adj" values. Team ___ [Enter your Team number in her] Task 0 : Adjusting Presidential Approval Ratings
4 Mini-Group Project 2 (8W section Fall’23), Team ____ You will use data in “Biden”, “Trump”, “Obama”, and “GWBush” worksheets to complete this task. a. Utilizing the given dataset, calculate a 95% confidence interval for the "Approving_adj" rate for each President. Keep in mind that this should be based on the adjusted Approval ratings you computed in Task 0. b. Identify which President has the narrowest and widest confidence intervals. Discuss potential factors, such as sample size or sample variance, that may influence these outcomes. Team ___ [Enter your Team number in her] Task 1 : Confidence Interval Estimations Task 2: Hypothesis Testing
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help