The Excel File Rins Gym provides sample data on member body characteristics and gym activity. Create PivotTables
Question:
The Excel File Rin’s Gym provides sample data on member body characteristics and gym activity. Create PivotTables to find:
a. A cross tabulation of gender and body type versus BMI classification
b. Average running times, run distance, weight lifting days, lifting session times, and time spent in the gym by gender.
Summarize your conclusions.
Step by Step Answer:
Rins Gym Gender Body Type BMI Classification BMI Calculation Time Spent in Gym Pant size inches Weig...View the full answer
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Related Video
Newton’s second law defines a force to be equal to a change in momentum (mass times velocity) per change in time. Momentum is defined to be the mass m of object times its velocity V. In this video, newton’s law of force and acceleration is explained by lifting a Suzuki Car.
Students also viewed these Business Communication questions
-
The Excel file Investment Returns provides sample data for the annual return of the S& P 500, and monthly returns of a stock portfolio and bond portfolio. Construct histograms for each data set and...
-
For the data in the Excel file Rins Gym, find the co-variances and correlations among height, weight, and BMI calculation.
-
The Excel file Sales Data provides data on a sample of customers. An industry trade publication stated that the average profit per customer for this industry was at least $ 4,500. Using a test of...
-
Write a program that takes two integer command-line arguments x and y and prints the Euclidean distance from the point (x, y) to the origin (0, 0).
-
Turn to Figure 2.8 and find the options for Canadian Natural Resources. Suppose you buy a June call option with exercise price $ 24, and the stock price in June is $ 28. a. Will you exercise your...
-
Refer to Figure 11.45. A square footing, 2 x 2 m in size, supports a column load of 300 kN. The soil characteristics are given in the figure. Field monitoring indicated that the foundation settlement...
-
Consider the following two alternatives for the installation of a pump: The effective annual interest rate is \(10 \%\). Determine the salvage value for pump A when the two pumps are competitive....
-
Jabber Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows: Jabber anticipates selling 220,000 jars with total...
-
What effect did the propaganda following the Boston Massacre have on the colonists?
-
Write a letter to the Smith's discussing the results of their tax return, remind them of any deduction substantiation rules they need to follow (receipts, mileage log, etc.), offer suggestions for...
-
Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach?
-
A national homebuilder builds single family homes and condominium style townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the...
-
Some populations initally grow exponentially but eventually level off. Equations of the form where M, A, and k are positive constants, are called logistic equations and are often used to model such...
-
The executive officers of Rouse Corporation have a performance-based compensation plan. The performance criteria of this plan is linked to growth in earnings per share. When annual EPS growth is 12%,...
-
Geraths Windows manufactures and sells custom storm windows for three-season porches. Geraths also provides installation service for the windows. The installation process does not involve changes in...
-
Cameron Company has a portfolio of debt investments that it has managed as a trading investment. At December 31, 2015, Cameron had the following balances related to this portfolio: debt investments,...
-
Sinise Industries acquired two copyrights during 2015. One copyright related to a textbook that was developed internally at a cost of 9,900. This textbook is estimated to have a useful life of 3...
-
Lexington Co. has the following equity investments on December 31, 2015 (its first year of operations). During 2016, Summerset Company shares were sold for \($9\),200, the difference between the...
-
In Exercises 8194, begin by graphing the absolute value function, f(x) = |x|. Then use transformations of this graph to graph the given function. h(x) = x + 4 - 2
-
(a) As Section 17.3 discusses, high-frequency sound waves exhibit less diffraction than low-frequency sound waves do. However, even high-frequency sound waves exhibit much more diffraction under...
-
What type of processproject, job shop, flow shop, and continuous flowwould most likely be used to produce the following? Explain your reasoning. a. Apple iPads b. Weddings c. Paper d. Tax preparation
-
Provide some examples of customer- and provider-routed services that you have encountered that are different from those described in this chapter. Can you identify any improvements to these processes?
-
Provide some examples of customer- and provider-routed services that you have encountered that are different from those described in this chapter. Can you identify any improvements to these processes?
-
Can we justify the acquisition of Peloton Interactive Inc using NPV assuming the initial investment is 10% of the total market value of the company, 5% constant growth rate for the next three years...
-
Rivan Co. is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million in a large building. The fixed asset applies three year MACRS for tax...
-
Mary would like to save $10,000 at the end of 5 years for a future down payment on a car. How much should she deposit at the end of each month in a savings account that pays 1.2%/a, compounded...
Study smarter with the SolutionInn App