Case study quantitative business analysis

Complete MBA 6300 Case Study No. 2_900.docxPreview the document .  Data file Case Study No. 2 Data_900.xlsxPreview the document

You will be expected to:

  • perform certain calculations discussed in the assigned reading in order to derive an answer for each problem.
  • use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.
  • have each worksheet be clearly labeled to identify the associated problem.to show all calculations or other work performed to derive your answer(s) for each problem.
  • have your spreadsheet be fully functional (i.e., configured to allow the reader to not only see all numerical values but also be able to see the underlying formula associated with each calculated value).
  • to label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.

No credit will be granted for problems that are not completed using Excel, for which your Excel worksheet is not fully functional, or for which you have not shown all of the calculations or other work performed to derive your answer(s). You may refer to the course textbooks, supplemental reading materials, online information, and your own notes in conjunction with completing the homework assignments.  Once you have completed the necessary calculations to solve each problem and answer the associated questions, select the hyperlink provided to submit your Excel spreadsheet and report for grading.

Rubric

Case Study Rubric (1)Case Study Rubric (1)CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeData20.0 ptsExcellentAll the information and calculations are present in requested format (separate tab for data set and questions, working excel functions).18.0 ptsGoodThe Excel spreadsheet is missing 1 or 2 items.16.0 ptsFairThe Excel spreadsheet is missing 3 or 4 items.12.0 ptsPoorThe Excel spreadsheet is missing 5 or more items. Wrong data format.20.0 pts
This criterion is linked to a Learning OutcomeModel Estimation20.0 ptsExcellentModels reflect the appropriate choice of independent and dependent variables.18.0 ptsGoodModels reflect one incorrect variable.16.0 ptsFairModel reflects more than one incorrect variable.12.0 ptsPoorNo model or wrong models.20.0 pts
This criterion is linked to a Learning OutcomeEvaluation of Statistics20.0 ptsExcellentEvaluation correctly identifies and interprets all relevant statistics.18.0 ptsGoodEvaluation either incorrectly identifies or does not identify one relevant statistic.16.0 ptsFairEvaluation either incorrectly identifies or does not identify two or more relevant statistics.12.0 ptsPoorNo evaluation.20.0 pts
This criterion is linked to a Learning OutcomeOrganization20.0 ptsExcellentThe Excel spreadsheet is very organized and very easy to read.18.0 ptsGoodThe Excel spreadsheet is moderately well organized but is a little difficult to read.16.0 ptsFairThe Excel spreadsheet appears to have some order. It can be read but is very difficult.12.0 ptsPoorThe Excel spreadsheet is poorly organized and unreadable.20.0 pts
This criterion is linked to a Learning OutcomeAnalysis and Conclusion20.0 ptsExcellentShows a thoughtful, in-depth analysis of a significant topic. The reader gains important insights.18.0 ptsGoodThe information provides reasonable support for an argument. The analysis includes most of the important criteria. The reader gains some insights.16.0 ptsFairThe information provides a little support for an argument. The analysis is very general. The reader gains few insights.12.0 ptsPoorThe argument is not clearly identified. The analysis is vague or not evident. The reader is confused.20.0 pts
Total Points: 100.0

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.