Purchase Solution

Use Excel

Not what you're looking for?

Ask Custom Question

42. Refer to the Baseball 2000 data in Appendix D, which reports information on the 30 Major League Baseball teams for the 2000 season.

a. At the .10 significance level, is there a difference in the variation of the number of stolen bases among the teams that play their home games on natural grass versus on artificial turf?

b. Create a variable that classifies a team's total attendance into three groups: less than 2.0 (million), 2.0 up to 3.0, and 3.0 or more. At the .05 significance level, is there a difference in the mean number of games won among the three groups?

c. Using the same attendance variable developed in part (b), is there a difference in the mean team batting average?

d. Using the same attendance variable developed in part (b), is there a difference in the mean salary of the three groups?

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Calculating present and future values

    FV= $7,000 Rate=i= 11% Number of periods=n=nper=5 Use PV function in MS Excel to get PV PV= ($4,154.16) or we can also use formula PV=FV/(1+i)^n=7000/(1+11%)^5=4154.159296 4.WHAT IS THE MOST YOU WOULD PAY TODAY FOR A PROMISE TO REPAY

  • Scatter Plots and Correlation Coefficients

    Compute the correlation coefficient by using columns in excel. You may use excel to do the hand computations. In other words you may use excel to sum up the column compute the squares of each column, etc. Answer any question in a word document.

  • Use Excel to Construct Confidence Intervals

    A few people would use 0.01 as the lower limit for "large". We can use 0.05 for this problem. Please see the attached for explanation. The solution uses Excel to construct confidence intervals.

  • Excel Solver for Trend Equation to Forecast

    c) Use Excel Solver to make exponential trend equation to forecast team value. d) Use Excel Solver to make linear trend equation to forecast team value.

  • difference between numeric data and text data

    Excel users can then use certain formulas to enable the Excel worksheet to automatically calculate, arrange, or process our data based on the command (formula) specified. When we enter text data into Excel, Excel handles the text data differently.

  • Assumptions

    7520 Test statistics and ANOVA test using Excel 1.What are the assumptions regarding a small two sample t-test and what Excel aid would you use to perform the test, Data Analysis or MacDoIt?

  • Interpreting data can be used by a manager of an organization.

    Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Dear Student: Here are some paragraphs on ways a manager can use excel. Best of luck in your studies! 1.

  • Product Mix Model using Excel Solver for MBI Corporation

    Problem: - Create a spreadsheet in Excel to represent this situation and then use the Excel add-in Solver to determine the optimal number of minutes of radio and TV advertising the store should use to maximize its sales.

  • Statistical Form Report on a Dataset

    164321 Statistical Form Report on a Dataset Please assist with these problems and use two separate Excel for each problem.

  • Use Excel to answer forecasting questions

    553607 Use Excel to answer forecasting questions Please see the attachment for 2 questions I need help with. Problem Please use the following data in MS Excel to answer the below questions (no need to send Excel file).

View More Related Solutions