Data analysis to solve problems and inform decision-making

Assignment Help Financial Management
Reference no: EM132598095

Project : You will use mathematical operations and data analysis to solve problems and inform decision-making. This project will enable you to refresh and refine your skills in math and statistics before tackling a real world data set and using a software application or analytic tool to analyze and display the data in a way that will inform decisions. Using a process similar to the qualitative research process, you will identify an issue or problems and use mathematical formulas or an analytic tool to derive a solution. You will construct graphs, charts, and tables as necessary to inform analysis and interpretation. Communicating key mathematical information, you will evaluate the results and draw analyses and validate them. This project will enable a deeper understanding of the connection between data and how it informs solutions to practical problems with potential impact on your organization or industry.

Over this two-week period, you will use mathematical operations and data analysis to solve problems and inform decision making. Your final assignment will be the creation of a comprehensive Excel workbook with supporting charts and graphs and a short analysis of the data.

This project will enable you to refresh and refine your skills in math and statistics before you tackle a real-world data set using Excel to analyze and display the data.

Quantitative reasoning uses a process similar to the qualitative research process in that you will first identify an issue or problem and then use mathematical formulas or an analytic tool to derive a solution. You will construct graphs, charts, and tables to display data and inform analysis and interpretation. You will evaluate the results of the information, draw analyses and validate them by applying them to the issue or problem.

This project will enable you to see the connection between data and how the use of quantitative analysis of that data informs solutions to practical problems with potential impact on your organization or industry.

There are 10 steps that lead you through this project. Each step should take about two hours to complete. Begin by watching the video above, which introduces the project as it might occur in the workplace, then continue with Step 1: Refresh Your Math, Statistics, and Excel Skills.

When you submit your project, your work will be evaluated using the competencies listed below. You can use the list below to self-check your work before submission.

1. Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment.

2. Develop coherent paragraphs or points so that each is internally unified and so that each functions as part of the whole document or presentation.

3. Tailor communications to the audience.

4. Use sentence structure appropriate to the task, message and audience.

5. Follow conventions of Standard Written English.

2.1. Identify numerical or mathematical information that is relevant in a problem or situation.

2. Employ mathematical or statistical operations and data analysis techniques to arrive at a correct or optimal solution.

3. Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data.

4. Employ software applications and analytic tools to analyze, visualize, and present data to inform decision-making.

Reference no: EM132598095

Questions Cloud

Which is true about the feed forward control system : Which is true about the feed forward control system? Cannot make corrections until a measurable error exists./ Is theoretically capable of perfect control
Corporate social responsibility or ethical culture : Pick one of the following terms for your research: Morals, principles, values, corporate social responsibility, or ethical culture.
What will the target cost per unit for the new game be : The going price for video games, and the firm wants to earn a target return on sales of 12%, what will the target cost per unit for the new game be?
Find cost of good sold and closing stock : Find Cost of good sold and Closing stock using Perpetual system using FIFO and Weighted Average methods and Economic Order Quantity and Total cost
Data analysis to solve problems and inform decision-making : You will use mathematical operations and data analysis to solve problems and inform decision-making.
Calculate annual depreciation amount for each project : Calculate annual depreciation amount for each project. Compute cash flow from operation for each project. Estimate net present value for each project
Compensation and benefits package related to the job : Explain what will be included in the compensation and benefits package related to the job.
Create a blog post describing the results : Create a blog post to document your ongoing field observations. Supplement your blog entry with scanned or uploaded examples from you field journal
Compute the total amount of direct labour hours : Compute the Total Amount of Direct Labour Hours used for making products M, N and O. Compute the Overhead Absorption Rate

Reviews

Write a Review

Financial Management Questions & Answers

  Discuss the importance of using the triple bottom line

Describe two (2) possible challenges you foresee for domestic companies that want to develop an international growth strategy.

  What would be effective rate of interest

What would be the effective rate of interest? Calculate the effective rate of interest. What proceeds will Hafers receive?

  Monthly compounding rate

how much would you have to invest yearly to fully fund the annuity in 50 years, again assuming a 6% monthly compounding rate?

  Using the constant growth rate model

Using the constant growth rate model (and data from Bloomberg) shows that the present value of expected dividends for the next five years for McDonald’s is only about $1.98.  How can such a large discrepancy in the two dollar values on the same date ..

  What is the net present value of the project

Orchard Farms has a pretax cost of debt of 7.29 percent and a cost of equity of 16.3 percent. The firm uses the subjective approach to determine project discount rates. The firm's tax rate is 35 percent and its debt-equity ratio is .48. The project h..

  Implied by the two outstanding debt issues

Assume that the overall cost of debt is the weighted average of that implied by the two outstanding debt issues.

  Bbb-rated corporate bond has yield to maturity

A? BBB-rated corporate bond has a yield to maturity of 7.8 %. What is the credit spread on the BBB? bonds?

  What does the word translation mean

What is a hedge? How does that differ from speculation? What does the word translation mean?

  Straight line depreciation schedule

Tried and true home repair is considering replacement of its bobcat. The old Machine cost $150,000 and was depreciated using a 5 year straight line depreciation schedule. The machine has been in operation for three years. It could be sold for $30,000..

  What is Castle State Bank ROA

Following data pertains to Castle State Bank. Balance Sheet: What is Castle State Bank's ROA?

  What is relationship between a stated interest rate and APR

What is APR? what is the relationship between a stated interest rate and an APR? If stated rate is 4% per year , calculate the APR when interest rate is compounded (a) annually and (b) monthly ?

  What is the standard deviation-variance of this portfolio

Consider the following information: Rate of Return If State Occurs State of Probability of Economy. Your portfolio is invested 32 percent each in A and C, and 36 percent in B. What is the expected return of the portfolio? What is the variance of this..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd