What decisions would you need to make when creating a worksheet to evaluate and analyze data?

Topic: What-If Analysis (2 spreadsheets – records/loans) / Reflection Paper

Format/Length: 2 Spreadsheets – 2.1 Records & 2.2 Loans | 1 Paper – APA Format / 1-2 pages

Due: 12 pm EST – Thursday, October 13th

Info: Please see the attached assignment details and spreadsheet templates. Please read assignment details carefully.

SUBMISSION REQUIREMENTS

1. Project2.1_Records.xlsx.file.
2. Project2.2_Loans.xlsx.file.
3. Project Reflection (see below).

PROJECT REFLECTION

a. What is the main purpose of using goal seek?
b. What were your additional amounts for monthly payments (in 1, Item 2), and what were the corresponding interest rates that Goal Seek found for each?
c. What decisions would you need to make when creating a worksheet to evaluatePart and analyze data?
d. What is one advantage of using scenarios?
e. What should you do before creating a scenario report to make the entries on the report easier to interpret?
f. What are the changing cells in a scenario?

attachment
Project2_What-IfAnalysis-CMST100G.pdf
attachment
EX_2.1.xlsx
attachment
EX_2.2.xlsx

Looking for a similar assignment? Get help from our qualified experts!

Our specialized Assignment Writers can help you with your custom paper today. 100% written from scratch

Order a Similar Paper Order a Different Paper