Purchase Solution

Data Analysis and Decision Making.

Not what you're looking for?

Ask Custom Question

Business Week's Guide to the Best Business Schools provides enrollment data on graduate business programs that it rates as the best in the United States. Specifically, this guide reports the percentages of women, minority, and international students enrolled in each of the top programs, as well as the total numbers of full time students enrolled in each program. Use the appropriate measures of central location to find the typical percentage of women, minority, and international students enrolled in these elite programs. These data are contained in the file P02_03.xls.

What I need:

1). Ok, I understand that I will have to use Excel for this problem. Also, I think I will need to use the mean to find the "average of all the values of the variable" (Albright, Winston, and Zappe, 2006). Am I to use the percentile function, also for selected summary measures? Which one applies? What I am asking for here is that within the text, it speaks of percentile and quartile. Are the quartiles related to certain quarters in a business year? I am sorry but I am not good in math and I have not taken statistics before and on top of this I am not knowledgable of Excel. I need your help!!

2). If I am correct in choosing the mean to do this problem, when I go to Excel and click on insert and function, do I choose Sum and will I then have a choice of choosing the percentile function?

Thank you in advance for your patience with me.

Attachments
Purchase this Solution
Solution Summary

The solution analyzes decision making through data analysis.

Solution Preview

Please see the attached file. If you keep the cursor on the corresponding Excel cell, it shows the formula to be used. Hope this helps.
Percentile refers to the value corresponding to a given estimated ...

Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • timeliness, accuracy, and relevance

    Hence, to ensure that data collection and analysis is relevant and useful for decision making, timeliness is must.

  • Decision making and Big Data

    Decision making feeds on information and the fundamental of information is data.

  • The Advantages and Disadvantages of Statistical Analysis

    153534 Business Management - Statistical Analysis Why is statistical analysis preferable to visual inspection ("eye-balling") of data when making managerial decisions?

  • Data Gathering and Analysis

    • Summarize the use of qualitative data to support business decision making. Consider different types of qualitative data collection and analysis methods and the ways in which they can support business decision making and strategies.

  • Decision support system (DSS)

    In relation to predictive analysis, (DSS) software efficient form of decision-making by utilizing analytical and report-writing features that enable users to translate raw business data into useful forms of decision support for important decision-making

  • Decision making in complex situations

    99102 Decision making in complex situations How do you make decisions when issues are complex? Once knowing what has to be decided and how the data stacks up, how do you proceed? Please see the attached file.

  • What do you think comprises a cost benefit analysis?

    Decision making is greatly improved by data analysis because it provides a clear overview of the hidden elements, trends and results present in a data and helps in making meaningful comparasions of data over time.

  • Executive Information: Impact on Executive Decision Making

    The study conducted by Leidner and Elam reveal the important contribution of the EIS to faster problem identification and decision-making as well as an extended analysis in the decision-making process.

  • Using the right analysis tool

    Can the software and tools replace experienced and seasoned managers? If the data is wrong, the whole decision making will be faulty because it will be based on wrong data.

  • Information resources and their use in business

    Nowduri, Srinivas (n.d.).Management information systems and business decision making: review, analysis, and recommendations. 2. Journal of Management and Marketing Research, Bloomsburg University of Pennsylvania.

View More Related Solutions