Purchase Solution

Statistical Difference Formula for Microsoft Access

Not what you're looking for?

Ask Custom Question

I am looking to design something in Microsoft Access, but not sure how to do the two statistical calculations.

For example, assume there are two columns of data labeled January and February. In each of these columns are the numbers 0-4.

Where 0=Blank Response, 1=Poor, 2=Fair, 3=Good, 4=Excellent

I want to know if there is a statistically significant difference between current month and prior month. The data is the result of a post event survey where the club attendees are surveyed on their experiences from the meeting. Food, Speaker, Meeting Location, ...

The specific questions I would like to know solutions/formulas for is if there is a statistical difference for top Box (Excellent) for month to month comparison. Then also for top two box (good and excellent).

What would the formula be for calculating each of the two questions above? Note, I will automatically dropout from the data all of the areas that have a 0 in them as they do not count or included in anyway in the calculations. Those are questions where the attendee skipped over the question.

Purchase this Solution
Solution Summary

This solution provides guidance on calculating statistical difference and significance between current months and prior months on survey results.

Solution Preview

Since you are using LIKERT type Scale, the best way is to calculate the column averages. Leave the 0 out as these are missing data points. For rest data points take the average score both for january and feb.
Now take the difference between the two averages and conduct the t- test to see whether the two ...

Purchase this Solution
Free BrainMass Quizzes
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

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

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Hypothesis Testing & Confidence Interval

    (STATISTICAL INFERENCES ABOUT TWO POPULATIONS) Use the following sample information to construct a 90% confidence interval for the difference in the two population means.

  • Research software licensing in general

    The difference between Microsoft Office and Microsoft Windows is described.

  • Utilizing MS Excel and SPSS in Managerial Decision-Making

    593110 Utilizing MS Excel and SPSS in Managerial Decision-Making Research Microsoft Excel, the statistical package for the social sciences (SPSS), and the legal and ethical aspects of surveys and data collection.

  • Finance Questions on Shares of Company

    Market Value of Microsoft Stock (after offering) $836,500,000 Total number of shares outstanding 23,193,000 Market Value per share FORMULA Offering Price $35.00 Difference per share ($35.00) Unsold shares 21,100,000

  • Statistical Choices Worksheet and SPSS or Excel Analysis

    ¢ Access the Pre-Post Test Score Data Set. This is the data for Study #2 introduced in the Statistical Choices worksheet in the zip file. â?¢ Analyze the data using SPSS or Excel based on the purpose of the study. â?

  • Compare the difference between the body mass index (BMI) values

    610340 Compare the difference between the body mass index (BMI) values Details: Statistical Report Write an 850-1200 word statistical laboratory report using, a Statistical Report."

  • Excel Tools

    Explain the difference between a relative cell reference and an absolute cell reference. In business, analysts and managers rely on numerical data and statistical tools and processes.

  • Help with Statistical Operations

    Using a Microsoft Word document, perform the following statistical operations on the fear of statistics data gathered at the beginning (pre) and in the middle (mid) of statistics courses: • State the research (directional) hypothesis and null hypothesis

  • New applications making a big difference

    Multi Media Players are yet another class of applications which will make a big difference to computer users in the next few years. There is also portable version of SKYPE for portable devices. E-mail access programs on portable devices.

View More Related Solutions