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

Global interior design market - __________ antennas transmit the signal in all directions. - Need tomorrow - Https ppo payroll pro inc com kiosk login login aspx - The shadow club characters - Sample informative speech outline on a person - Do not go gentle into that good night worksheet answers - General Psychology - Heavy armoured glove crossword clue - Mise en scene film studies - Oxygen lewis dot structure - Day of mourning 1938 - Romeo and juliet symbols - System breach - Maternity case studies for nursing students - UNIT VIII POWER POINT MBA 6001 - Las vegas to eureka ca - Differences between booker t washington and web dubois essay - Brief one page summary on the use of privately owned and run prisons in America - Cost accounting chapter 3 solutions - When were advos introduced - Erin danielle company purchased equipment and incurred the following costs: - Hr to employee ratio cipd - Robinson crusoe friday relationship - Family health assessment part 2 - The curse of atreus - Dc circuit physics lab report - Nature/nurture - Brooks dfo south wharf - Greek mythology family tree - Does prospero free caliban - Should the american dream be capitalized - Top 100 catalog retailers - Asperger Syndrome - Leadership - Abcb protocol for building energy analysis software - Another word for firstly secondly thirdly - Week 5 socioautobiography audio powerpoint - Casio fx 991ex random number - Cell structure and function experiment - What is the risk adjusted npv of each project - Interstitial and appositional growth - Piercemil instructure - My johari window essay - Disadvantages of Corporate Social Responsibility - Organic Chemistry 1 - The goal a process of ongoing improvement book summary - Algorithm to solve a 2x2 rubik's cube - Back to back stem and leaf plot worksheet - Pride of india tree - Orpheus by alice low - Prince2 foundation practice exam - How does latitude and longitude affect climate - I have read and understood the policy - Which of the following scheduling algorithms could result in starvation - Domestic building contracts regulations - Aseptic technique nsw health - Dsdm consortium website - Toyota - Three dimensional structure of pcl3 - Engineering ethics charles b fleddermann pdf - Cost structure refers to the relative proportion of - Doing ethics technique - Reed cover letter template - Macbeth kills macduff's family - Are order effects an extraneous variable - Chartered accountants ireland cpd requirements - What is psycap self assessment - Serial number lookup bicycles - Secure software development concepts support protecting applications - Process Essay - Research Paper - Va nurse 2 proficiency example - Why discovery course review - Neeraj kanwar net worth - Everett rogers change theory in nursing - Week 4 Assignment: Essay – The Holocaust - Consolidation of commonwealth anti discrimination laws - College algebra equation - Aeroplane reference field length - NRS-410V-0L191 Pathophisiology and Nursing Management of Client Health. - Business case study - APA style 6 pages - NEEDS A General Chemistry II EXPERT! - Basic concept ati template example - Diversity wheel exercise - Psychology physics and maths tutor - Coding assignment - A loaf of poetry - Cascaded amplifier gain formula - You can grow your intelligence answers - Business Research Methodology - Professional authority form uts - Dr bradley rapid city sd - Cougar cordless drill batteries - Bushfire survival situation expert answers - Much wenlock medical practice - Gate f botanical gardens melbourne - How to pronounce pneumonoultramicroscopicsilicovolcanoconiosis backwards - Zinc and hydrochloric acid lab - Gregorian chant hildegard von bingen