EBK BUSINESS STATISTICS
7th Edition
ISBN: 8220102743984
Author: STEPHAN
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 2, Problem 2.61AC
(a)
To determine
To construct: A table that tallies type, market cap, risk and rating.
(b)
To determine
To conclude:about the differences among the types of funds based on market cap based on type, risk and rating
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The following table shows a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008. . The data set includes the following five variables:
Use Excel to answer the following question:
a. Prepare a crosstabulation of the data on Fund Type (row variable) and the average annual return over the past 5 years (column variable). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for the 5-Year Average Return (%) (Class width is 10).
B. Construct frequency distributions for Fund Type and 5-Year Average Return (%) respectively. Based on the frequency distributions of the two variables, which of the following answers is wrong?
Group of answer choices
Out of the 45 mutual funds, there are 2 funds with 5-year average return of 30 - 40 (%).
Out of the 45 mutual funds, there are 28 funds with 5-year average return of 10 - 20 (%).
Out of the 45 mutual funds, there are 28 DE type of funds.
Out of the 45 mutual funds, there are 10…
A stock has monthly returns of 9%, 22%, 15%, and 28%. What is the stock's geometric average
return?
The selling prices of mutual funds change daily. In order to study these changes, a sample of mutual funds was examined and the daily changes in price are listed below. (Round answers to 3 decimal places)
0.32, -0.17, 0.26, -0.03, -0.01, 0.18, 0.33, 0.28, 0.02, -0.29, -0.08, 0.12, 0.07, 0.03, 0.28
a) Using a calculator find Q1, Q3, median and IQR
b) Determine the lower and upper fences. (Show work)
c) Identify the outliers (if any) in this set
Chapter 2 Solutions
EBK BUSINESS STATISTICS
Ch. 2 - Prob. 2.1LBCh. 2 - The following data represent the responses to two...Ch. 2 - Prob. 2.3ACCh. 2 - Prob. 2.4ACCh. 2 - Prob. 2.5ACCh. 2 - Prob. 2.6ACCh. 2 - Prob. 2.7ACCh. 2 - A survey of 1,085 adults asked Do you enjoy...Ch. 2 - Prob. 2.9ACCh. 2 - Prob. 2.10AC
Ch. 2 - Prob. 2.11LBCh. 2 - Prob. 2.12LBCh. 2 - Prob. 2.13LBCh. 2 - Prob. 2.14LBCh. 2 - The file NBACost2013 contains the total cost ($)...Ch. 2 - The file UTILITY contains the following data about...Ch. 2 - Prob. 2.17ACCh. 2 - One operation of a mill to cut pieces of steel...Ch. 2 - A manufacturing company produces steel housings...Ch. 2 - Prob. 2.21ACCh. 2 - Prob. 2.22ACCh. 2 - Prob. 2.23ACCh. 2 - An online survey of CFA Institute members was...Ch. 2 - Prob. 2.25ACCh. 2 - Prob. 2.26ACCh. 2 - Prob. 2.27ACCh. 2 - The following table indicates the percentage of...Ch. 2 - Prob. 2.29ACCh. 2 - Prob. 2.30ACCh. 2 - A study of Kickstarter projects showed that 54.2%...Ch. 2 - Prob. 2.32ACCh. 2 - Prob. 2.33LBCh. 2 - Prob. 2.34LBCh. 2 - Prob. 2.35ACCh. 2 - Prob. 2.37ACCh. 2 - The file UTILITY contains the following data about...Ch. 2 - Prob. 2.39ACCh. 2 - Prob. 2.40ACCh. 2 - Prob. 2.41ACCh. 2 - Prob. 2.42ACCh. 2 - Prob. 2.43ACCh. 2 - Prob. 2.45ACCh. 2 - Prob. 2.46ACCh. 2 - The data stored in DRINK represents the amount of...Ch. 2 - Prob. 2.48LBCh. 2 - Prob. 2.49LBCh. 2 - Prob. 2.50ACCh. 2 - Data were collected on the typical cost of dining...Ch. 2 - College football is big business, with coaches pay...Ch. 2 - Prob. 2.54ACCh. 2 - Prob. 2.56ACCh. 2 - Prob. 2.57ACCh. 2 - Prob. 2.58ACCh. 2 - Prob. 2.59ACCh. 2 - Prob. 2.60ACCh. 2 - Prob. 2.61ACCh. 2 - Prob. 2.66ACCh. 2 - Prob. 2.67ACCh. 2 - Prob. 2.68ACCh. 2 - Prob. 2.69ACCh. 2 - Prob. 2.71ACCh. 2 - (Student Project) The Data and Story Library...Ch. 2 - Prob. 2.73ACCh. 2 - Prob. 2.75ACCh. 2 - Figure 2.1 shows a bar chart and a pie chart for...Ch. 2 - Prob. 2.78ACCh. 2 - Prob. 2.79CYUCh. 2 - Prob. 2.80CYUCh. 2 - Prob. 2.81CYUCh. 2 - Compare and contrast the bar chart for categorical...Ch. 2 - Prob. 2.83CYUCh. 2 - Prob. 2.84CYUCh. 2 - What are the three different ways to break down...Ch. 2 - How can a multidimensional table differ from a...Ch. 2 - Prob. 2.87CYUCh. 2 - Prob. 2.88CRPCh. 2 - The owner of a restaurant that serves...Ch. 2 - Suppose that the owner of the restaurant in...Ch. 2 - Prob. 2.94CRPCh. 2 - One of the major measures of the quality of...Ch. 2 - Prob. 2.98CRPCh. 2 - The file CEO-Compensation includes the total...Ch. 2 - Prob. 2.100CRPCh. 2 - What was the average price of a room at two-star,...Ch. 2 - Prob. 2.102CRPCh. 2 - Prob. 2.103CRPCh. 2 - The following data (stored in Drink) represent...Ch. 2 - Prob. 2.106CRPCh. 2 - Prob. 2.109RWE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- 4. Compare the high and the low common stock prices since 2007 in a graph of your choice for "XXX" Corporation. Write a brief interpretation of the main features of the data portrayed in the graph. The high and the low common stock prices for the "XXX" Corporation since 1983 are: Year High Low 2007 40.85 30.90 2008 40.85 30.00 2009 40.85 29.25 2010 48.00 34.00 2011 64.75 32.00 Year High Low 2013 72.00 45.75 2014 81.65 63.25 2015 80.15 63.50 2016 75.35 60.25 2017 98.35 67.75 2018 99.00 70.00 2012 51.75 39.65arrow_forwardUse the accompanying data table regarding retirement funds. Complete parts (a) through (d) below. a. Construct a growth and value table that tabulates type, market cap, risk,and rating.arrow_forwarda. Compute the covariance between first weekend gross and national gross, first weekend gross and worldwide gross, and national gross and worldwide gross.arrow_forward
- I need help with part Aarrow_forwardThe following table shows the total return and the number of funds for four categories of mutual funds. Excel File: data03-17.xlsx Type of Fund Domestic Equity International Equity Specialty Stock Hybrid a. Using the number of funds as weights, compute the weighted average total return for these mutual funds. (to 2 decimals) % Number of Funds 9,191 2,621 1,419 2,900 Total Return (%) 4.65 18.15 11.36 6.75 b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights? (i) Using "number of funds" as weights will only be a good approximation if the amount invested in various funds is approximately equal. The amount invested in each fund could be used for weights. (ii) Using "number of funds" as weights results in a good approximation regardless of the amount invested in various funds. There is no need to use a different weight. (iii) Using "number of funds" as…arrow_forward6. Estimate the value of sales for the year 1985 by using the method of least square for trend analysis. Year: 1979 1980 1981 1982 1983 Sales: 100 120 140 160 180 (*000 quintals)arrow_forward
- I need some help with sections D, E, and F pleasearrow_forwardThe following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors (aaii.com, February 2002). Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts. Click on the datafile logo to reference the data. For the Exchange variable, show the "frequency and the percent frequency" for AMEX, NYSE, and OTC. Frequency & Percent Frequency for each: AMEX (? ) (? ), NYSE (? ) (? ), OTC ( ? ) ( ? ) Total (? ) (? )arrow_forwardThe following table shows the total return and the number of funds for four categories of mutual funds. Excel File: data03-17.xlsx Type of Fund Number of Funds Total Return (%) Domestic Equity 9,191 4.65 International Equity 2,621 18.15 Specialty Stock 1,419 11.36 Hybrid 2,900 6.75 b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights? (i) Using "number of funds" as weights will only be a good approximation if the amount invested in various funds is approximately equal. The amount invested in each fund could be used for weights. (ii) Using "number of funds" as weights results in a good…arrow_forward
- Most Expensive Colleges Listed below are the annual costs (dollars) of tuition and fees at the 10 most expensive colleges in the United States for a recent year (based on data from U.S. News & World Report). The colleges listed in order are Columbia, Vassar, Trinity, George Washington, Carnegie Mellon, Wesleyan, Tulane, Bucknell, Oberlin, and Union. What does this “top 10” list tell us about those costs for the population of all U.S. college tuitions?arrow_forwardBelow are percentages for annual sales growth and net sales attributed to loyalty card usage at 74 Noodles & Company restaurants. Annual Sales Growth (px;) and Loyalty Card Usage (px; of Net Sales)(n = 74 restaurants) Store Growth% Loyalty% Store Growth% Loyalty% 1 -7.8 0.7 38 7.3 1.5 2 -6.9 2.5 39 7.4 1.7 3 -5.1 1.6 40 7.7 2.3 4 -4.7 1.4 41 8.0 2.0 5 -3.8 2.5 42 8.0 1.6 6 -1.7 1.5 43 8.3 1.9 7 -1.7 2.6 44 8.4 2.0 8 -1.6 2.4 45 8.6 2.2 9 -1.1 2.2 46 8.6 1.6 10 -1.0 1.9 47 8.7 0.9 11 0.4 1.2 48 8.9 1.7 12 0.6 0.5 49 9.4 1.6 13 0.6 2.1 50 9.5 1.3 14 1.0 1.3 51 9.5 2.1 15 1.3 2.0 52 10.5…arrow_forwardSuppose the Dow Jones Industrial Average went up 149.82 points. The following table shows the stock price changes for a sample of 12 companies on that day. PRICE CHANGE PRICE CHANGE COMPANY $ COMPANY $ AFLAC 0.81 JOHN&JOHN 1.46 BANK AMERICA 0.05 LOEWS CP 0.92 CABELVISION 0.41 NOKIA 0.21 DIAGEO 1.32 SMPRAENGY 0.97 FLOUR CP 2.37 SUNOCO 0.52 GOODRICH 0.4 TYSON FOOD 0.22 Provide 95% confidence interval estimates of the populatioin vairance and the population standard deviation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Types of Data: Nominal, Ordinal, Interval/Ratio - Statistics Help; Author: Dr Nic's Maths and Stats;https://www.youtube.com/watch?v=hZxnzfnt5v8;License: Standard YouTube License, CC-BY
Statistics 1.1.2 Types of Data; Author: Dr. Jack L. Jackson II;https://www.youtube.com/watch?v=UZ4kHJOuoec;License: Standard YouTube License, CC-BY