Purchase Solution

Excel (Megastat) Problems

Not what you're looking for?

Ask Custom Question

Excel (Megastat) problems
--------------------------------------------------------------------------------
If you could do the work in Excel (Megastat) and highlight the answers. Then write out the answer in the word document or excel- just have the Megastat table below the answer.

I am not very good at Excel unless Megastat is used. Please use Megastat so I can learn how to solve these types of problems.

Thanks for all your help you are very thorough and efficient!!

Attachments
Purchase this Solution
Solution Summary

Solution attaches an Excel spreadsheet using Megastat to work out 4 basic statistic testing questions.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Regression Equation with Megastat

    104800 Regression Equation with Megastat Simply need to know how to go about formulating the equation for the attached problem in an Excel format in order to answer this problem and problems like this one. Please see the attached file.

  • Hypothesis Testing

    Megastat Procedure: Copy and paste your data into Excel in a single column. I am assuming that you have Megastat ADD-IN added to your Excel. If so, select add-in, then Megastat, then Hypothesis Test, then Mean vs. Hypothesized value.

  • Correlation and Regression Analysis

    C) Determine the coefficient of correlation (Use Megastat or Excel, Tools, Data Analysis, Regression function). Interpret the result.

  • ANOVA and regression problem set

    The attached twelve page Word document contains solutions to the ANOVA and regression problems in this set. This 2000 word set of solutions includes plots and output tables from MegaStat, an Excel add-in.

  • Correlation Coefficient, Coefficient of Determination and ANOVA

    Use Excel or Megastat to determine the following correlations of analysis: X 2 3 5 5 10 y 6 9 14 16 30 a. Place the Excel or Megastat results here: b. What is the coefficient of correlation? (place in box) c.

  • Use Excel or Megastat to determine the following Correlation

    308279 Use Excel or Megastat to determine the following Correlation Use Excel or Megastat to determine the following correlations of analysis: X 2 3 5 5 10 y 6 9 14 16 30 a. Place the Excel or Megastat results here: b.

  • How to Perform Multiple Regression with Excel and Megastat

    308880 Multiple Regression & Seasonal Forecasting This solution describes how to do multiple regression using Excel and the Megastat plugin.

  • Hypothesis Testing & Correlation Coefficient

    Complete an ANOVA table by using Excel or Megastat. Copy and paste your Excel or Megastat worksheet that shows the ANOVA table for this exercise. d. What is your decision about Ho? 5.

  • Correlation analysis in Megastat

    (b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. (c) Use Excel or Appendix D to find t.05 for a two-tailed test. (d) Calculate the t test statistic. (e) Calculate the critical value of rα.

View More Related Solutions