

The last will then briefly list all of the options and note briefly what data/input is expected and any unique aspects of each option.

The second chapter will work through one option in detail. The first chapter will describe the general operating procedures and conventions that are common throughout MegaStat. The purpose of this Getting Started document is to introduce you to how MegaStat works. After it is installed it appears on the Excel menu and works like any other Excel option. Butler University MegaStat 12 is an Excel add-in that performs statistical analyses within an Excel workbook.
Megastat excel 2013 free download series#
Hypothesized Value.26 Compare Two Independent Proportions.26 Analysis of Variance One-Factor ANOVA.27 Randomized Blocks ANOVA.28 Correlation / Regression Scatterplot.29 Correlation Matrix.30 Regression Analysis.30 Predictor values from spreadsheet cells Type in predictor values Select Options: Select Residuals options Time Series / Forecasting Trendline Curve Fit.33 Deseasonalization.34 Moving Average Exponential Smoothing.35 Simple Exponential Smoothing Two-factor Exponential Smoothing Chi-Square / Crosstab Contingency Table.36 Crosstabulation.37 Goodness of Fit Test.38 Nonparametric Tests Sign Test.39 Runs Test for Random Sequence.39 Wilcoxon Mann/Whitney Test.40 Wilcoxon Signed Rank Test.40 Kruskal Wallis Test.41 Friedman Test.42 Kendall Coefficient of Concordance.42 Spearman Coefficient of Rank Correlation.43 Fisher Exact Test.43 Quality Control Process Charts Control chart for variables (Xbar and R chart).44 Control chart for proportion nonconforming (p chart).44 Control chart for number of defects per sample (c chart).44 iiiĤ Getting Started with MegaStat J. Hypothesized Values.24 iiģ Compare Two Independent Groups Paired Observations.25 Proportion vs. 8 Example 2: Normal Distribution Example 3: Entering Proportions Reference Descriptive Statistics Frequency Distributions Quantitative.16 Qualitative.17 Probability Counting Rules.20 Discrete Probability Distributions.21 Continuous Probability Distributions.21 Confidence Intervals / Sample Size Confidence interval mean.22 Confidence interval p.22 Sample size mean.23 Sample size p.23 Hypothesis Tests Mean vs. 7 Help System.7 About MegaStat Tutorial Examples. 6 Insert descriptive information.6 Start new output sheet.6 Delete output sheet.6 Deactivate MegaStat.6 Uninstall MegaStat.6 Help/Information. OrrisĢ Table of Contents Getting Started with MegaStat Basic Procedures. Orris Butler University Copyright 2001 by J.
