Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to create a frequency table in minitab

22/10/2021 Client: muhammad11 Deadline: 2 Day

Minitab And Excel

Assignment 1

Create frequency and summary tables for categorical data

Background: The data provided are from a larger study on college students which also included students’ pulse rate before and after running, height, weight, and exercise level. Since we are only dealing with categorical variables here, I deleted all the other data. Still, the data regarding the smoking status can be seen as a sample taken from the population of college students, since the subjects were enrolled randomly.

Raw data are in posted the Excel file: Class 6 Assignment raw data - smoking status among college students.xls

Use Excel and minitab to carry out the counts of the raw data for each combination of category values.

Combine the frequency counts into a 2-way frequency table.

Calculate the respective proportions and create a 2-way summary table.

Note: This task is very common and very basic, so you should know how to do this in Excel. You may not have minitab available all the time. Plus the minitab worksheet isn’t the best format to work with tables (see below).

Part A. Using Excel

I created a youtube tutorial to walk you through all the steps of this assignment.

http://www.youtube.com/watch?v=RrXRoJDO90U

Watch it until 30 min, 30 seconds. Skip the last 10 minutes! I screwed up a little with my wording for the row and column proportions. Better use the wording I put below.

So here are the steps (as shown in the video as well):

1. Create a frequency table and a summary table for the raw data, in the same worksheet, next to the raw data (as shown in the video).

2. For the frequency table, use the Excel formula COUNTIFS to get the counts automatically inserted into your table fields.

3. Then calculate the marginal totals and the grand total.

4. For the summary table, use the frequencies to calculate the joint proportions.

5. Next, calculate the row proportions and the column proportions and list them in rows underneath the table (not within the table, so these proportions won’t get confused with the joint proportions of the table).

Row proportions in this example:

Proportion of all males that smoke / don’t smoke (=100%)

Proportion of all females that smoke / don’t smoke (=100%)

Column proportions in this example

Proportion of all smokers that are male / female (=100%)

Proportion of all non-smokers that are male / female (=100%)

[You see, there are a lot of ways to calculate proportions. Be sure to keep them apart and when you see a number for a proportion, ask or verify what that proportion actually is.]

When you are done, save the file twice (as I mention in the video): Once with the original title, plus your name, to upload as a homework. Then save it again, calling it “Template to create frequency and summary tables for categorical data.xls” or something like that...

So now each time you have categorical data, you just paste them into the columns of this template and your tables are generated automatically. That may come in handy for the midterm.

(Tip: since you don’t want to lose the template, just always save it under a new name as soon as you enter new data.)

PART B. Generating tables from categorical data with Minitab

1. Copy the 2 columns of raw data into a Minitab worksheet.

2. Then go to Stat > Tables > Descriptive Statistics

3. Fill out the minitab popup menu (it already has found your columns with data):

In your mind, imagine the table you just created in Excel. Or draw a quick sketch of a table.

You want the values for the variable “gender” in separate rows. So these are your row variables. You want the values for the smoking status in separate columns. So these are your column variables. (The convention is to put the variable that predicts an outcome in rows and the variable that measures the outcome in columns. In this case, gender might or might not predict smoking status, but definitely not the other way round!)

4. Put your cursor in the field “For rows”.

5. Click on C2 Gender (it will turn blue)

6. Click the select button. C2 Gender will appear in the field “for rows”.

7. Repeat for the field “For columns” with the variable C1 Smokes.

Note: If you had more columns with variables, these would be treated as layers. Here you don’t have any.

8. Click on “Display summaries for Categorical Variables”

9. In the new menu that appears, check off the box for “Counts” (and nothing else!)

10. Click OK.

Note: You may be tempted to check off all boxes, since in the end we want all of these data. But if you do, the output will be a mess of numbers that are hard to sort (I’ll show you further below). So it pays off to do this one by one.

11. Click OK again on the menu.

12. Your frequency table will appear in the results box for the session. It should look like this:

Notice that minitab calculated the marginal totals as well. So we didn’t need to tell it.

This is done by default.

(It could be switched off in the options box.)

13. Mouse over the field with the table to have a little arrow appear. Click on it and select “copy”

14. Paste the table into an Excel worksheet (maybe in another tab in the same file than you used for the first part of this homework). Note: Tables are much easier to deal with in an Excel worksheet than in a minitab worksheet.

15. Call the table “Frequency table”.

[[optional: To confirm what I just said, paste the same table into the minitab worksheet. It will probably look like this:]]

Minitab doesn’t keep the column headings

straight, but shifts them to the left.

16. Repeat steps 2-14, this time selecting “Total percents”. These correspond to the joint proportions you calculated in Excel. Copy output table into the same Excel worksheet.

17. Call the table “Summary table”

18. Repeat steps 2-14, selecting “Row percents”. Copy result into Excel. Make sure to label the table as “Row percents”.

19. Repeat steps 2-14, selecting “Column percents”. Copy result into Excel.

At this point you will most likely have noticed that minitab is not calculating proportions but percentages.

It’s the same thing, but percentages may be a bit more user-friendly. For doing statistics however they need to be converted back to proportions (which happens in the background with these stats packages, so one doesn’t need to worry).

To show you what I meant, this is what happen when you select the counts and all the percentages to be calculated at once: Here’s the output in the minitab Session result field:

and this is how it looks like when pasted into a minitab worksheet.

There are probably ways to fix this and make it look nicer, but I am not a minitab expert.

Additional Resources:

EXCEL:

Help file for COUNTIFS function and the COUNTIF function (PDF posted on Blackboard)

(also check out what the COUNTIF function can do, even though it can’t be used here).

Microsoft video tutorial for COUNTIFS function

https://support.office.com/client/en-us/videoplayer/embed/RWeqXB?pid=ocpVideo0-innerdiv-oneplayer&jsapi=true&postJsllMsg=true&maskLevel=20&market=en-us

COUNTIFS function is explained in the first 2 min 30 seconds, then the SUMIFS function is explained

Minitab:

https://support.minitab.com/en-us/minitab/18/help-and-how-to/statistics/tables/supporting-topics/basics/table-analyses-in-minitab/

This opens the first page for the help section on table analysis. You can then click your way through the menu on the left.

Also note: minitab has a function that tallies (counts) values for variables in a column. Just like the Excel COUNTIF function, it can’t be used to count across multiple values or criteria in different columns.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Professional Coursework Help
Essay Writing Help
Financial Analyst
Homework Guru
Phd Writer
Financial Hub
Writer Writer Name Offer Chat
Professional Coursework Help

ONLINE

Professional Coursework Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$27 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$18 Chat With Writer
Financial Analyst

ONLINE

Financial Analyst

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$43 Chat With Writer
Homework Guru

ONLINE

Homework Guru

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$29 Chat With Writer
Phd Writer

ONLINE

Phd Writer

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$25 Chat With Writer
Financial Hub

ONLINE

Financial Hub

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$37 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Project management chapter 6 solutions - Grundfos sololift installation instructions - Percentage of copper in brass experiment - VARK Analysis Paper - Past tense of arise - Formula for ageing calculation in excel - Coke vs diet coke floating experiment - A model for predictive measurements of advertising effectiveness - Health Information technology presentation - Santa barbara city college - The snow man wallace stevens - Week 2 Discussion - Democratic party vs republican party essay - Phonetic alphabet letter g - Assignment - Economics 2 - Sunpower e series vs x series - The Remarkable Thing About Group Development - Due to erratic sales of its sole - Hp officejet 6100 cartridge lights blinking - Effective Speaking - Securities exchange act of 1934 auditor liability - Robert arias recently inherited a stock portfolio - Thomas nagel the absurd - Forces affecting global integration and global marketing pdf - Fixed-time period models are used when demand is variable - Conclusion for superposition theorem - How to make a contribution format income statement - Maslow's hierarchy of needs mnemonic - Falling from grace characters - At&t swot analysis - Cryptography and Network Security - How to oil the gears in poptropica wild west - Atp pc system food source - Finance - Michael caine acting in film book pdf - Business ethics multiple choice questions pearson - Parts of a recipe - Tableau desktop specialist practice exam - The saunders investment bank has the following financing outstanding. - A brief history of psychology - Balanced and unbalanced forces worksheet - Charismatic leaders use active impression management - Lab 2 - Ucl division of surgery and interventional science - Basic router and switch configuration - Five ways to disappoint your vietnamese mother - When a factory is operating in the short run - Counselling for civil servants - 1 mole of aluminum - Discussion - Csec english sba reflection sample - Perceptual set definition psychology - Wk 16 - Informing candidates of interview decisions - 2 coments each one 150 words (CITATION AND REFERENCE) - SINS MEETING - Business ethics joseph w weiss pdf download - Cfa bushfire management statement - Carna group pty ltd - AB=+1 - Prepare the following adjusting entries at august 31 for walgreens - Ethics, Law and Cybersecurity - Fantastic mr fox pictures from the book - Commonwealth bank eftpos machine error codes - Robin hood homework - Floor plan door size - 7 grammar mechanics checkup 4 adjectives and adverbs - Reasons to go to boston university - Gottman relationship checkup questions - Classical approach to management - 5 Literature Review - Nursing concept Diabetes - Cultural presentation psy 450 - Final Research Paper - week 13/14 - Death of a salesman monologue female - Question & Answer - Market penetration assignment due in 18 hours - What is an implied theme - Define the key biographical characteristics - Individual - Aqa pse 5800 resources - Sarah-reply to discussion board - Examples of nursing interventions and rationales - Why does the kkk burn crosses - Charles by shirley jackson questions - Adafruit pwm servo driver tutorial - Westfield black friday opening times - TD- Human Comm. DIS 2- - What is the purpose of a cirt plan - Capsim final company performance summary - Project charter example for a wedding - 2 coments each one 150 words (CITATION AND REFERENCE) - Calculate ph of original buffer - HSA 599 WEEK 7 - Aromatherapy consultation form template - Recycled plastic tiles machine - Which decelerates faster a badminton shuttlecock or a baseball - Apriori property - Huawei vision and mission 2018