Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Getting Familiar with Minitab
Rating: 4.6 out of 5(979 ratings)
13,546 students

Getting Familiar with Minitab

Managing Data in a Worksheet with Minitab
Created byLászló Bognár
Last updated 1/2018
English
English

What you'll learn

  • Use the platform of the Minitab software to manipulate data in a worksheet and use it for basic statistical computations. Get the skill of choosing the appropriate tools of Minitab for a specific data analysis problem. Get ready to start the courses "Foundation of Statistics with Minitab" and "Statistical Methods for Quality Improvement" where Minitab is the tool to make the different statistical concepts clear and easy to understand using its capabilities to spectacularly visualize the hidden structure of data.

Course content

2 sections • 12 lectures • 44m total length

  • Introduction and Sample Data to Download3:06

    Explore the basics of Minitab, manipulate data, rank, sort, and recode, and learn to explore data tables using built-in sample data without extra downloads.

  • Getting Started4:44

    Explore the basics of Minitab, including the main window, menu bar, tool bar, session window and data window, and how worksheets organize variables, observations, and data entry.

  • Summarizing Cases, Row Statistics6:48

    Analyze each student's rows by calculating means, medians, and weighted averages using row statistics and calculator in Minitab, then round results as needed.

  • Summarizing Columns, Using Session Commands5:47

    Learn to manage worksheet columns in Minitab, compute column means like Test1, store results as constants, and use session commands and display options to view outputs.

  • Coding Data2:38

    Learn to recode numerical data to text in Minitab by creating a Grade column from C10 scores and mapping 90 to 100 to A, 80 to 89 to B.

  • Ranking and Sorting of Data4:06

    Rank and sort data in Minitab using the rank and sort commands to order students by rounded weighted mean scores, handling ties by averaging ranks.

  • Standardizing Data2:55

    Standardize data by centering on the mean and dividing by the standard deviation to enable cross-test comparisons. Use Calc > Standardize to select scores, store results, and interpret trends.

  • Creating Subsets of Worksheet2:03

    Create a subset worksheet in Minitab by filtering for grade F, using the condition 'Grade equals F' with quotes, producing a sheet with C1–C15 for the three F students.

  • Combining Data using the Stack Option3:19

    Stack test scores from Test1, Test2, and Test3 into a single column with subscripts using Minitab's stack option, then compute the overall mean via column statistics.

  • Separating Data using the Unstack Option2:40

    Use unstack columns to create columns C18–C22 labeled A, B, C, D, and F from C10, mapping 90–100 to A and 80–89 to B, with 16 A–C and 8 D–F.

Requirements

  • Download and install Minitab. Version 17.1 is used in the video lectures but earlier or later versions can also be used since little changes have been made in the way of manipulating data.

Description

Get familiar with the tools, functioning and use of the Minitab statistical software package that you will need to analyze big data and make decisions about problems arising in business, production or engineering.

Get the skills of manipulating data in a worksheet when you are analyzing data.

  • Summarizing data in rows of a worksheet or data of variables in columns using numerical descriptive statistics.
  • Coding your data to different types.
  • Ranking and sorting your data.
  • Creating subsets of your data.
  • Combining or separating your data.

Animated video lessons about the process of manipulating data to prepare yourself to start learning the statistical methods of data analysis.

The video lessons give step-by step instructions you to select the appropriate menu commands or to write session window commands for specific problems. Screen animations highlight the important details of a session or draw your attention to the "tricks" applied. You can turn on subtitles to help follow the instrucions and explanations. Sample data of Minitab are used for demonstration so you do not need to download any additional dataset.

It is a short course including 10 lectures, a little more than half an hour, yet comprehensive and well enough to get the skill of using Minitab's capabilities for datasheet manipulation and to enable you to start real world data analysis in the next courses of "Foundation of Statistics with Minitab" or "Statistical Methods for Quality Improvement".

Watching a video, pausing it and doing the same steps simultaneously in your own Minitab is the best way of getting experience and practice in data manipulation. Repeating the sessions with different sample data develops your skill to easily handle big data files and helps you reach the stage when you feel that data analysis is a fun when you can have a look behind the scenes.

Who this course is for:

  • It is great for students learning Statistics at their universities and for those who start using Statistics in their job. Especially for those dealing with quality matters in production or service sectors Minitab is the best choice. It is one of the most popular statistical computing packages in the world. The reason of its popularity is the easy to use menus and self-explanatory output windows and graphs.

Report abuse