Accessing data from separate worksheets in Minitab

S

statty

#1
Hi,
Is it possible to access data from different worksheets in Minitab (like with relative addressing in Excel). For example I have data in two worksheets and would like to create a third worksheet using data from the other two such as adding a column of data from worksheet1 to a column from worksheet 2 and storing the result in worksheet3. Is this possible? Also, If I was to plot a scatter plot with multiple Y's based on data from different worksheets, is this possible?

Any suggestions are welcome,
Thanks!
 
Elsmar Forum Sponsor

Stijloor

Staff member
Super Moderator
#2
Hi,
Is it possible to access data from different worksheets in Minitab (like with relative addressing in Excel). For example I have data in two worksheets and would like to create a third worksheet using data from the other two such as adding a column of data from worksheet1 to a column from worksheet 2 and storing the result in worksheet3. Is this possible? Also, If I was to plot a scatter plot with multiple Y's based on data from different worksheets, is this possible?

Any suggestions are welcome,
Thanks!
Can someone with Minitab expertise help?

Thank you!!

Stijloor.
 
A

Allattar

#3
Not as far as I have found.
Graphs and stats are generated on individual worksheets, not across worksheets.

The Merge worksheet tool will merge worksheets, but wont merge and stack if that is what you are after. You can merge worksheets and then stack after of course.

The old chestnut of copy and paste between worksheets is pretty easy though.
In keyboard shortcut terms rather than through the menus.
CTRL+N select new worksheet.
Select column number, eg C1 to select the column or range of coumns CTRL+C <copy> and CTRL+V <paste>. In case you hadnt found those windows defaults.

I hope that sounds reasonable, rather than some flashy way of combining data, that I can suggest a fairly simple answer as this.
 
S

steelejc15425

#4
Allattar is correct that Minitab won't let you make a graph from multiple worksheets. Nor, as in Excel, is there a feature to access data from multiple worksheets. You can however, merge worksheets to create a new one, as you propose:
"I have data in two worksheets and would like to create a third worksheet using data from the other two such as adding a column of data from worksheet1 to a column from worksheet 2 and storing the result in worksheet3."

To find this in Minitab help, you have to know that Minitab calls this "merge worksheet". You can search for it there or you can open the Data > Merge Worksheets and look at the examples there.

It will let you either copy columns directly from two worksheets into another (the "include columns" option), or, if you have a column in common between the two worksheets, it will let you match up the rows (the "by columns" option). Note that once you make the third worksheet, changes to the other two won't change the data in the new worksheet.

If your data starts out in Excel, there are also some things you can do with ODBC where Minitab will read the current data from the Excel file every time that you open it.
 
Thread starter Similar threads Forum Replies Date
M Informational EU – M2M Data Exchange available services for accessing MDR EUDAMED data available for Economic Operator (EO) organisations Medical Device and FDA Regulations and Standards News 0
L Getting Notice of Revision and Accessing Public Draft Copies of ISO Standards Service Industry Specific Topics 2
M Accessing Assist.daps AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
Sidney Vianna Accessing the Xenforo version of Elsmar via a smartphone Elsmar Xenforo Forum Software Instructions and Help 8
J Accessing and Using Databases via a Tablet Device Quality Assurance and Compliance Software Tools and Solutions 4
A Accessing Medical Device Adverse Event databases in EU CE Marking (Conformité Européene) / CB Scheme 7
DuncanGibbons Technical Data Package vs Digital Product Definition APQP and PPAP 0
Z Putting back excluded rows/data points in a control chart Using Minitab Software 0
F General Data Protection Regulation (GDRP) CE Marking (Conformité Européene) / CB Scheme 6
Z Minitab - Updating Graph with specific data points Using Minitab Software 2
E PEMS Hazards - IEC 60601 Clause 14.6 - Internal data use - Pressure sensor IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
K Transform variable data into attribute data Reliability Analysis - Predictions, Testing and Standards 24
R Clinical evaluation without clinical data - MDR Article 61(10) EU Medical Device Regulations 6
H Capability Data for Paint Thickness on Painted Parts Statistical Analysis Tools, Techniques and SPC 10
D BS EN 62304 - Medical-Relevant Data C.5 - Definition of IEC 62304 - Medical Device Software Life Cycle Processes 5
T Submitting MR Compatibility Data for 510(k) Cleared Device Other Medical Device and Orthopedic Related Topics 2
S Quality manager considering data science Quality Manager and Management Related Issues 19
A What are Practical data center best practices IEC 27001 - Information Security Management Systems (ISMS) 0
U Do we need clinical trial data for Class IIa medical device under MDR EU Medical Device Regulations 7
S Average and standard deviation of Cumulative Data Statistical Analysis Tools, Techniques and SPC 5
V IS/ISO/IEC 17025:2017 Clause 7, sub clause 7.11 Control of data and information management ISO 17025 related Discussions 1
Watchcat CERs Literature Databases - Searching for data to evaluate EU Medical Device Regulations 16
D Transformation of Data Normality Failed Using Minitab Software 11
J Sample size for creating a data base as a reference to a tested variable Other Medical Device and Orthopedic Related Topics 6
M GUDID data deficiency communication - IS THIS A SCAM? ISO 13485:2016 - Medical Device Quality Management Systems 29
H Question about implications of performing Firmware upgrade via MDDS - Medical Device Data Systems 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
R Demonstrate how sufficient levels of access to data is achieved - Claims of equivalence EU Medical Device Regulations 3
R Material safety data sheet (MSDS) related clause in IATF 16949 manual IATF 16949 - Automotive Quality Systems Standard 17
CPhelan Using clinical trial safety data for evidence for CE marking EU Medical Device Regulations 7
M Informational US FDA – MDR Data Files – Alternative Summary Report Data Since 1999 Available Medical Device and FDA Regulations and Standards News 0
CPhelan Do you require MDSAP for CE Marking of a Medical Device or is ISO13485:2016 with clinical data sufficient? CE Marking (Conformité Européene) / CB Scheme 5
M Data analysis Design of Experiments Using Minitab Software 3
S Seeking efficient method to manage install base data Manufacturing and Related Processes 0
V Every good documentation practice observation is an data integrity issue US Food and Drug Administration (FDA) 7
M Informational US – National Evaluation System for Health Technology Coordinating Center (NESTcc) Solicits Public Comments for Data Quality and Methods Frameworks Medical Device and FDA Regulations and Standards News 0
M Informational Eudamed Data Exchange Guidelines Medical Device and FDA Regulations and Standards News 0
M Informational EU – Eudamed Data exchange services and entity models introductions Medical Device and FDA Regulations and Standards News 4
V What is the criteria to cite an good documentation practices observation as an data integrity related issue US Food and Drug Administration (FDA) 6
D Do we need normal data for gage r&r studies? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
M Automatic Data Gathering Requirements and Privacy Implications Medical Information Technology, Medical Software and Health Informatics 0
R Over read of physiological data by technicians EU Medical Device Regulations 0
L How to evaluate the process capability of a data set that is non-normal (cannot be transformed and does not fit any known distribution)? Capability, Accuracy and Stability - Processes, Machines, etc. 12
M Informational EU – EUDAMED UDI Device Data Dictionary + data sets Medical Device and FDA Regulations and Standards News 0
F Mig Welded Components - IMDS International Material Data System RoHS, REACH, ELV, IMDS and Restricted Substances 1
L SPC - Methods to collect data IATF 16949 - Automotive Quality Systems Standard 7
M Informational MDCG 2019-4 Timelines for registration of device data elements in EUDAMED Medical Device and FDA Regulations and Standards News 0
M Informational FDA Panel: Too early to pull textured breast implants over cancer risk, need more data Medical Device and FDA Regulations and Standards News 0
M Informational Health Canada begins release of clinical data Medical Device and FDA Regulations and Standards News 0
M (How To) Getting Data From Vision Machine To Reporting Software Misc. Quality Assurance and Business Systems Related Topics 0
S Minitab - Factor Analysis: Label on second series of data for Biplot Using Minitab Software 4

Similar threads

Top Bottom