ACCT 3130 Mid-Term Exam Part 2 Section 005 - Spring 2022.
ACCT 3130 – Section 005 – Spring
2022 Mid-Term Exam, Part 2
Instructions:
Enter all of your answer responses and screenshots in the provided Mid-Term Exam, Part
2 document. You must upload all documents and files to the “Quizzes” section of Canvas
for the Mid-Term Exam as outlined below:
You are also required to turn in the adjusted data/excel files you used to answer the exam
questions. Label each excel worksheet with the Question #s from the exam.
Thus, you are required to turn in 3 files:
1) Mid-Term Exam, Part 2 Word file (Upload as the response to Question #2)
2) Mortgage_2017 excel file – Adjusted (Upload as the response to Question #3)
3) RIA Excel file – Adjusted (Upload as the response to Question #4)
Failure to turn in the required excel files results in the penalty of 10 points for each file not
submitted. I will not accept any email submissions. Please be cognizant of your exam time
as no submissions will be accepted after expiration of the exam time.
Honesty Statement: I pledge to not share files, documents or information from this exam
with any other person, website or organization. Violation of this pledge will result in a
formal academic dishonesty charge to be filed by the professor and processed according to
Clemson University’s academic integrity policy. By typing my name below, I am
indicating my agreement with this statement.
Student’s Full Name:
Section #:
NOTE!!!!!
For answer responses in dollars, you must correctly extend the dollar amounts or your
answer will be marked wrong. For example, if the data is reported in 000s, and your
calculated result is $5462, then you should properly report $5,462,000 as your answer
response. This is a non-negotiable so if you do not properly extend the $ amounts, your
answer will be marked wrong and there will be no adjustments later for it. Not all
responses should be $ amts. BE SURE TO ANSWER ALL PARTS OF THE
QUESTIONS.
This study source was downloaded by 100000832558064 from CourseHero.com on 04-19-2022 05:57:51 GMT -05:00
https://www.coursehero.com/file/134751803/ACCT-3130-Mid-Term-Exam-Part-2-Section-005-Spring-2022docx/
, ACCT 3130 Mid-Term Exam Part 2 Section 005 - Spring 2022.
SCREENSHOTS must include your entire screen or
you will not receive points.
Use the following data files to answer Questions 1-6: (Hint: You may need to
merge files/data/tables to answer some of the questions)
Source: The mortgage_2017 is obtained from the Consumer Financial Protection Bureau, which
is publicly available data. The original data can be found in the following link and we use only
fraction of the data for this exam purposes:
https://www.consumerfinance.gov/data-research/hmda/
“mortgage_2017” data includes the following attributes: agency_name, applicant_income_000s,
as_of_year, county_code, county_name, loan_purpose, msa_code, state_abbr, state_name,
loan_amount_000s. The data dictionary for the “mortgage_2017” data is available in the
“Mortgage_2017 Data Dictionary” word file.
“msa_code” data includes the following columns: msa_code and msa_name. The data dictionary
for the “msa_code” data is available in the “msa_code data dictionary” word file.
“Loan_purpose_code” data includes the following columns: loan_purpose_code and
loan_purpose_name. The data dictionary for the “Loan_purpose_code” data is available in the
“Loan Purpose Code Data Dictionary” word file.
Question 1. (10 points)
List the top five states as measured by total $ dollar amounts of loan applications filed.
Enter the state names here with their Total Loan $ amts in order from highest to lowest:
Copy and paste the properly sorted pivot table (by $ amt in descending order) screenshot here:
This study source was downloaded by 100000832558064 from CourseHero.com on 04-19-2022 05:57:51 GMT -05:00
https://www.coursehero.com/file/134751803/ACCT-3130-Mid-Term-Exam-Part-2-Section-005-Spring-2022docx/
ACCT 3130 – Section 005 – Spring
2022 Mid-Term Exam, Part 2
Instructions:
Enter all of your answer responses and screenshots in the provided Mid-Term Exam, Part
2 document. You must upload all documents and files to the “Quizzes” section of Canvas
for the Mid-Term Exam as outlined below:
You are also required to turn in the adjusted data/excel files you used to answer the exam
questions. Label each excel worksheet with the Question #s from the exam.
Thus, you are required to turn in 3 files:
1) Mid-Term Exam, Part 2 Word file (Upload as the response to Question #2)
2) Mortgage_2017 excel file – Adjusted (Upload as the response to Question #3)
3) RIA Excel file – Adjusted (Upload as the response to Question #4)
Failure to turn in the required excel files results in the penalty of 10 points for each file not
submitted. I will not accept any email submissions. Please be cognizant of your exam time
as no submissions will be accepted after expiration of the exam time.
Honesty Statement: I pledge to not share files, documents or information from this exam
with any other person, website or organization. Violation of this pledge will result in a
formal academic dishonesty charge to be filed by the professor and processed according to
Clemson University’s academic integrity policy. By typing my name below, I am
indicating my agreement with this statement.
Student’s Full Name:
Section #:
NOTE!!!!!
For answer responses in dollars, you must correctly extend the dollar amounts or your
answer will be marked wrong. For example, if the data is reported in 000s, and your
calculated result is $5462, then you should properly report $5,462,000 as your answer
response. This is a non-negotiable so if you do not properly extend the $ amounts, your
answer will be marked wrong and there will be no adjustments later for it. Not all
responses should be $ amts. BE SURE TO ANSWER ALL PARTS OF THE
QUESTIONS.
This study source was downloaded by 100000832558064 from CourseHero.com on 04-19-2022 05:57:51 GMT -05:00
https://www.coursehero.com/file/134751803/ACCT-3130-Mid-Term-Exam-Part-2-Section-005-Spring-2022docx/
, ACCT 3130 Mid-Term Exam Part 2 Section 005 - Spring 2022.
SCREENSHOTS must include your entire screen or
you will not receive points.
Use the following data files to answer Questions 1-6: (Hint: You may need to
merge files/data/tables to answer some of the questions)
Source: The mortgage_2017 is obtained from the Consumer Financial Protection Bureau, which
is publicly available data. The original data can be found in the following link and we use only
fraction of the data for this exam purposes:
https://www.consumerfinance.gov/data-research/hmda/
“mortgage_2017” data includes the following attributes: agency_name, applicant_income_000s,
as_of_year, county_code, county_name, loan_purpose, msa_code, state_abbr, state_name,
loan_amount_000s. The data dictionary for the “mortgage_2017” data is available in the
“Mortgage_2017 Data Dictionary” word file.
“msa_code” data includes the following columns: msa_code and msa_name. The data dictionary
for the “msa_code” data is available in the “msa_code data dictionary” word file.
“Loan_purpose_code” data includes the following columns: loan_purpose_code and
loan_purpose_name. The data dictionary for the “Loan_purpose_code” data is available in the
“Loan Purpose Code Data Dictionary” word file.
Question 1. (10 points)
List the top five states as measured by total $ dollar amounts of loan applications filed.
Enter the state names here with their Total Loan $ amts in order from highest to lowest:
Copy and paste the properly sorted pivot table (by $ amt in descending order) screenshot here:
This study source was downloaded by 100000832558064 from CourseHero.com on 04-19-2022 05:57:51 GMT -05:00
https://www.coursehero.com/file/134751803/ACCT-3130-Mid-Term-Exam-Part-2-Section-005-Spring-2022docx/
