ACCP476_HWAssignmentInstructions_2022-09-02

.pdf

School

CUNY Hunter College *

*We aren’t endorsed by this school

Course

476

Subject

Accounting

Date

May 8, 2024

Type

pdf

Pages

8

Uploaded by BarristerRainDeer10 on coursehero.com

ACCP 476 HW Assignment Instructions updated September 2, 2022 Directions for All Homework Assignments: All commands must be written by you from scratch. Sharing identical lines of code is not allowed. Do not submit any portions of MY code. o Do not use any variable names with “zazz”, which is contained in the .pdf o If any of your variable names have “zazz” in them, you will receive a 0 for the entire homework grade. You must submit your entire LOG file, which begins with - - - - - - and ends with - - - - - -. Failure to copy the entire log file will result in a 0 for the entire homework grade. Homework #1 (Parts 1 and 2) In Stata, write (from scratch) the following commands 2 different times (Log #1 and Log #2). When you are finished, copy the contents of your .txt file and input into Blackboard. Part 1 Log #1 1. Change the directory (cd). 2. Activate your LOG command: log using lastname_firstname_YYYY-MM-DD-version 3. Do the change directory function (cd) again. 4. IMPORT the file topic1_2013-01-FallGrades_2021-08-19.xlsx and tab for ACC 102. 5. Replace any missing grades with 0. 6. Calculate the quiz average after dropping the lowest quiz. What is EWCH’s quiz average? EWCH’s quiz average = .75 7. What is the median and 75 th percentile of the class’s quiz average? Median = .9, P75 = .95 8. SAVE the file as: topic1_HW_102quiz. 9. CLOSE (using log close), then TRANSLATE the log file 10. Copy and paste the contents of the .txt file into Blackboard for Log #1. Log #2 Repeat the steps in Log #1, but change the order of the Stata commands you used. Copy and paste the contents of the .txt file into Blackboard Log #2. Part 2 Go to Blackboard, and practice writing the Stata commands. This exercise is “fill in the blank”, and you get unlimited attempts. Homework #2 (Parts 1 and 2) Part 1 In Stata, write (from scratch) the following commands 2 different times. When you are finished, copy the contents of your .txt file and input into Blackboard. Log #1 1. Change the directory (cd). page 1 of 8
ACCP 476 HW Assignment Instructions updated September 2, 2022 2. Activate your LOG command: log using lastname_firstname_YYYY-MM-DD-version 3. Do the change directory function (cd) again. 4. IMPORT the file topic1_2013-01-FallGrades_2021-08-19.xlsx and tab Attendance_Messy. 5. Calculate each student’s attendance % (ROWTOTAL , MAX). Hint: There are 3 different classes with different numbers of class meetings. 6. What is the median and 75 th percentile of the attendance score for ACC 102? Answer: median = .916667, 75 th percentile = 1 7. SAVE the file as: topic1_HW_Attendance. 8. CLOSE (using log close), then TRANSLATE the log file 9. Copy and paste the contents of the .txt file into Blackboard for Log #1. Log #2 Repeat the steps in Log #1, but change the order of the Stata commands you used. Copy and paste the contents of the .txt file into Blackboard Log #2. Part 2 Go to Blackboard, and practice writing the Stata commands. This exercise is “fill in the blank”, and you get unlimited attempts. Homework #3 (Parts 1, 2, and 3) Part 1 In Stata, write (from scratch) the following commands 2 different times. When you are finished, copy the contents of your .txt file and input into Blackboard. Log #1 1. Change the directory (cd). 2. Activate your LOG command: log using lastname_firstname_YYYY-MM-DD-version 3. Do the change directory function (cd) again. 4. USE the topic1_HW_102quiz file from the previous assignment. Merge the file to topic1_HW_attendance by Username Use either merge 1:1 or just merge (when you are not certain the data is 1:1) Keep any student listed in the 102quiz file. Fill in any missing attendance average as 0. 5. Calculate the overall score using the four components: Final Exam (25%) Exam 1 (25%) Average Quiz Grade, Drop Lowest (25%) Attendance Average (25%) What is STDA’s overall score? STDA = 77.16666 6. SAVE the file as: topic1_HW_102overall. 7. Make the following three tables. All tables must be formatted correctly with Times New Roman. See the example tables at the end of Part 3. Make Table 1 Descriptive Statistics with Final Exam, Exam 1, Quiz Grade, and Attendance. page 2 of 8
ACCP 476 HW Assignment Instructions updated September 2, 2022 Make Table 2 Correlation Table with Final Exam, Exam 1, Quiz Grade, and Attendance. Make Table 3 Regression Analysis. Run a regression with the Final Exam as the dependent variable and Exam 1, Quiz Grade, and Attendance as independent variables. 8. CLOSE (using log close), then TRANSLATE the log file 9. Copy and paste the contents of the .txt file into Blackboard for Log #1. Log #2 Repeat the steps in Log #1 (steps 1-4 only), but change the order of the Stata commands you used. Copy and paste the contents of the .txt file into Blackboard Log #2. Part 2 Go to Blackboard, and upload the Excel file with Table 1 (Descriptive Statistics), Table 2 (Correlation Table), and Table 3 (Regression Analysis). Part 3 Go to Blackboard, and upload the .PDF with Table 1 (Descriptive Statistics), Table 2 (Correlation Table), and Table 3 (Regression Analysis). Table 1 – Descriptive Statistics Grade Components for ACC 101 (N = 6) Mean Q1 Median Q3 Std.Dev Final Exam 0.30 0.00 0.29 0.60 0.33 Midterm Exam 0.54 0.00 0.71 0.85 0.43 Quiz Average 0.43 0.27 0.41 0.73 0.29 Attendance Average 0.42 0.00 0.25 1.00 0.49 Note: Data is from Fall 2013. Table 2 – Correlations Pearson Correlations for ACC 101 (N = 6) Final Exam Midterm Exam Quiz Average Midterm Exam 0.7660* Quiz Average 0.7698* 0.8919** Attendance Average -0.5443 -0.8122** -0.5900 *, **, *** indicates correlation is significant at the 10%, 5%, and 1% level, respectively. Data is from Fall 2013. Table 3 – Regression Analysis page 3 of 8
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