(a) Explanation Given: RetirementFunds: Calculation: To construct a table that tallies type, risk and rating: 1) Select Insert PivotTable. In the Create PivotTable dialog box: 2) Click Select a table or range and enter A1:N317 as the Table/Range. 3) Click New Worksheet and then click OK. In the pivot table pane; 4) Drag Type in the Choose fields to add to report box and drop it in the Row Labels box. 5) Drag Risk in the Choose fields to add to report box and drop it in the Row Labels box. 6) Drag Star Ratings in the Choose fields to add to report box and drop it in the Row Labels box. 7) Drag Type in the Choose fields to add to report box and drop it in the S VALUES box. 8) Click the dropped label Count of Type and click Value Field Setting in the shortcut menu. 9) Click the Show Values As tab and select Normal from the Show values as drop- down list. 10) Click OK. Count of Type Column Labels Row Labels Five Four One Three Two Grand Total Growth 18 76 16 74 43 227 Average 3 15 6 28 22 74 High 1 5 (b) To determine To find: the number of fundsand the conclusions about the funds

Business Statistics: A First Course (7th Edition)

7th Edition

ISBN: 9780321979018

Author: David M. Levine, Kathryn A. Szabat, David F. Stephan

Publisher: PEARSON

See similar textbooks

Concept explainers

Inverse Normal Distribution

The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of tw…

Mean, Median, Mode

It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency o…

Z-Scores

A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow compar…

Videos

Question

Chapter 2, Problem 2.68AC

(a)

To determine

To construct: a table that tallies type, risk and rating.

(b)

To determine

To find: the number of fundsand the conclusions about the funds

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 2, Problem 2.67AC

Chapter 2, Problem 2.69AC

Students have asked these similar questions

1 (VaR and ES) Suppose X ~ f(x) with 1+x, if 0> x > −1 f(x) = 1−x if 1 x > 0 Find VaRo.05 (X) and ES0.05 (X).

Joy is making Christmas gifts. She has 6 1/12 feet of yarn and will need 4 1/4 to complete our project. How much yarn will she have left over compute this solution in two different ways

Solve for X. Explain each step. 2^2x • 2^-4=8

Chapter 2 Solutions

Business Statistics: A First Course (7th Edition)

Ch. 2 - Prob. 2.1LB Ch. 2 - The following data represent the responses to two...Ch. 2 - Prob. 2.3AC Ch. 2 - Prob. 2.4AC Ch. 2 - Prob. 2.5AC Ch. 2 - Prob. 2.6AC Ch. 2 - Prob. 2.7AC Ch. 2 - A survey of 1,085 adults asked Do you enjoy...Ch. 2 - Prob. 2.9AC Ch. 2 - Prob. 2.10AC

Ch. 2 - Prob. 2.11LB Ch. 2 - Prob. 2.12LB Ch. 2 - Prob. 2.13LB Ch. 2 - Prob. 2.14LB Ch. 2 - The fileÂ NBACost2013Â contains the total cost ($)...Ch. 2 - The file UTILITY contains the following data about...Ch. 2 - Prob. 2.17AC Ch. 2 - One operation of a mill to cut pieces of steel...Ch. 2 - A manufacturing company produces steel housings...Ch. 2 - Prob. 2.21AC Ch. 2 - Prob. 2.22AC Ch. 2 - Prob. 2.23AC Ch. 2 - An online survey of CFA Institute members was...Ch. 2 - Prob. 2.25AC Ch. 2 - Prob. 2.26AC Ch. 2 - Prob. 2.27AC Ch. 2 - The following table indicates the percentage of...Ch. 2 - Prob. 2.29AC Ch. 2 - Prob. 2.30AC Ch. 2 - A study of Kickstarter projects showed that 54.2%...Ch. 2 - Prob. 2.32AC Ch. 2 - Prob. 2.33LB Ch. 2 - Prob. 2.34LB Ch. 2 - Prob. 2.35AC Ch. 2 - Prob. 2.37AC Ch. 2 - The file UTILITY contains the following data about...Ch. 2 - Prob. 2.39AC Ch. 2 - Prob. 2.40AC Ch. 2 - Prob. 2.41AC Ch. 2 - Prob. 2.42AC Ch. 2 - Prob. 2.43AC Ch. 2 - Prob. 2.45AC Ch. 2 - Prob. 2.46AC Ch. 2 - The data stored in DRINK represents the amount of...Ch. 2 - Prob. 2.48LB Ch. 2 - Prob. 2.49LB Ch. 2 - Prob. 2.50AC Ch. 2 - Data were collected on the typical cost of dining...Ch. 2 - College football is big business, with coaches pay...Ch. 2 - Prob. 2.54AC Ch. 2 - Prob. 2.56AC Ch. 2 - Prob. 2.57AC Ch. 2 - Prob. 2.58AC Ch. 2 - Prob. 2.59AC Ch. 2 - Prob. 2.60AC Ch. 2 - Prob. 2.61AC Ch. 2 - Prob. 2.66AC Ch. 2 - Prob. 2.67AC Ch. 2 - Prob. 2.68AC Ch. 2 - Prob. 2.69AC Ch. 2 - Prob. 2.71AC Ch. 2 - (Student Project)Â The Data and Story Library...Ch. 2 - Prob. 2.73AC Ch. 2 - Prob. 2.75AC Ch. 2 - FigureÂ 2.1Â shows a bar chart and a pie chart for...Ch. 2 - Prob. 2.78AC Ch. 2 - Prob. 2.79CYU Ch. 2 - Prob. 2.80CYU Ch. 2 - Prob. 2.81CYU Ch. 2 - Compare and contrast the bar chart for categorical...Ch. 2 - Prob. 2.83CYU Ch. 2 - Prob. 2.84CYU Ch. 2 - What are the three different ways to break down...Ch. 2 - How can a multidimensional table differ from a...Ch. 2 - Prob. 2.87CYU Ch. 2 - Prob. 2.88CRP Ch. 2 - The owner of a restaurant that serves...Ch. 2 - Suppose that the owner of the restaurant in...Ch. 2 - Prob. 2.94CRP Ch. 2 - One of the major measures of the quality of...Ch. 2 - Prob. 2.98CRP Ch. 2 - The fileÂ CEO-CompensationÂ includes the total...Ch. 2 - Prob. 2.100CRP Ch. 2 - What was the average price of a room at two-star,...Ch. 2 - Prob. 2.102CRP Ch. 2 - Prob. 2.103CRP Ch. 2 - The following data (stored inÂ Drink) represent...Ch. 2 - Prob. 2.106CRP Ch. 2 - Prob. 2.109RWE

Knowledge Booster

$Statistics$

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.

To construct: a table that tallies type, risk and rating.

Solution Summary: The author explains how to construct a table that tallies type, risk and rating.

Concept explainers

Videos

To construct: a table that tallies type, risk and rating.

To find: the number of fundsand the conclusions about the funds

Want to see the full answer?

Chapter 2 Solutions