SlideShare a Scribd company logo
Organizing and
Presenting Data
Create a table using Excel:
1. Open new document (Excel).
2. Type Title (A1).
3. Input values for independent variable
   (mass, angle, length) in column A2.
4. Label columns (Time Period) for the 3
   trials (Time 1, Time, 2, Time 3).
5. Enter values for all trials.
6. Set formula to get average of 3 trials.
    Type: =average(then highlight data-B3:D#)   Tips:
                                                1. Merging Cells
                                                   Right click  Format cell
                                                   alignment  merge
                                                2. Fixing average values
                                                   Right click  Format cells
7. Copy and Paste other cells
                                                    number  Select 2
8. Edit table (center, justify, etc).              decimal places
9. Set Borders
Create a graph using Excel:
1. Select and drag down first column (independent variable)
    click control key  select and drag down
      average Time period column
2. Click Insert  Select chart 
  Choose XY scatter .
3. Click Chart Layout  Select Layout 10
4. Click Axis Title, label X and Y axis
5. To delete background, left double click,
  select delete.




                                          6. Save graph or paste in a Word
                                             document.
                                          7. Add appropriate title to graph.
Using the graph to predict swing height:
1. Right click on any data point in the graph
    Select Add Trend line  Select Power.
2. Making projections: (target- 2.8 sec)
   Backward forecast: enter number lower
   than shortest length (9.99- this shows
   curve of line from 0)
   Forward forecast: Right click on trend line
    Format trend line  Options 
   Forward  enter 50 or higher
3. Finding 2.8 sec (Time Period):
   Left Double click anywhere on scale 
   Format axis  Scale  Change major
   unit (5 or 10) for X axis Change major
   unit for Y axis (0.2)
4. Mark predicted length based on a 2.8
   Time Period.
PLAYGROUND DESIGN LAB
       (Swings)
Ad

More Related Content

What's hot (20)

Introduction to Excel
Introduction to ExcelIntroduction to Excel
Introduction to Excel
Najma Alam
 
Ms excel
Ms excelMs excel
Ms excel
Muhammad Adeel Shoukat
 
22-excel-basics-15511.ppt
22-excel-basics-15511.ppt22-excel-basics-15511.ppt
22-excel-basics-15511.ppt
20ArnavKumar8F
 
MS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training CourseMS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training Course
Ranjan Jena
 
Charts in EXCEL
Charts in EXCELCharts in EXCEL
Charts in EXCEL
pkottke
 
M.S EXCEL
M.S EXCELM.S EXCEL
M.S EXCEL
Alvin Maderista
 
Microsoft Excel Tutorial
Microsoft Excel TutorialMicrosoft Excel Tutorial
Microsoft Excel Tutorial
Kristine Tiongco-Rimpa
 
Ppt on pivot table
Ppt on pivot tablePpt on pivot table
Ppt on pivot table
Hemendra Vyas
 
Conditional formatting - Excel
Conditional formatting - ExcelConditional formatting - Excel
Conditional formatting - Excel
Yi Chiao Cheng
 
Microsoft Office Excel 2003 Sorting And Filtering
Microsoft Office Excel 2003 Sorting And FilteringMicrosoft Office Excel 2003 Sorting And Filtering
Microsoft Office Excel 2003 Sorting And Filtering
Marc Morgenstern
 
Insert + design
Insert + designInsert + design
Insert + design
rimshailyas1
 
Microsoft Word: Working with Tables
Microsoft Word: Working with TablesMicrosoft Word: Working with Tables
Microsoft Word: Working with Tables
Tiffany Johnson
 
Data Analytics Using MS Excel
Data Analytics Using MS ExcelData Analytics Using MS Excel
Data Analytics Using MS Excel
Rajesh Math
 
Formatting in MS Excel
Formatting in MS ExcelFormatting in MS Excel
Formatting in MS Excel
Muhammad Yasir Bhutta
 
Lesson 1 Excel Introduction
Lesson 1 Excel IntroductionLesson 1 Excel Introduction
Lesson 1 Excel Introduction
wats300
 
Spreadsheet formulas ppt (1)
Spreadsheet formulas ppt (1)Spreadsheet formulas ppt (1)
Spreadsheet formulas ppt (1)
Tammy Carter
 
Making a Chart Using Excel
Making a Chart Using ExcelMaking a Chart Using Excel
Making a Chart Using Excel
rebelbrindley
 
Types Of Charts
Types Of ChartsTypes Of Charts
Types Of Charts
wmassie
 
Excel PowerPoint
Excel PowerPointExcel PowerPoint
Excel PowerPoint
nhumar
 
Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table
Alomgir Hossain
 
Introduction to Excel
Introduction to ExcelIntroduction to Excel
Introduction to Excel
Najma Alam
 
22-excel-basics-15511.ppt
22-excel-basics-15511.ppt22-excel-basics-15511.ppt
22-excel-basics-15511.ppt
20ArnavKumar8F
 
MS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training CourseMS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training Course
Ranjan Jena
 
Charts in EXCEL
Charts in EXCELCharts in EXCEL
Charts in EXCEL
pkottke
 
Conditional formatting - Excel
Conditional formatting - ExcelConditional formatting - Excel
Conditional formatting - Excel
Yi Chiao Cheng
 
Microsoft Office Excel 2003 Sorting And Filtering
Microsoft Office Excel 2003 Sorting And FilteringMicrosoft Office Excel 2003 Sorting And Filtering
Microsoft Office Excel 2003 Sorting And Filtering
Marc Morgenstern
 
Microsoft Word: Working with Tables
Microsoft Word: Working with TablesMicrosoft Word: Working with Tables
Microsoft Word: Working with Tables
Tiffany Johnson
 
Data Analytics Using MS Excel
Data Analytics Using MS ExcelData Analytics Using MS Excel
Data Analytics Using MS Excel
Rajesh Math
 
Lesson 1 Excel Introduction
Lesson 1 Excel IntroductionLesson 1 Excel Introduction
Lesson 1 Excel Introduction
wats300
 
Spreadsheet formulas ppt (1)
Spreadsheet formulas ppt (1)Spreadsheet formulas ppt (1)
Spreadsheet formulas ppt (1)
Tammy Carter
 
Making a Chart Using Excel
Making a Chart Using ExcelMaking a Chart Using Excel
Making a Chart Using Excel
rebelbrindley
 
Types Of Charts
Types Of ChartsTypes Of Charts
Types Of Charts
wmassie
 
Excel PowerPoint
Excel PowerPointExcel PowerPoint
Excel PowerPoint
nhumar
 
Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table
Alomgir Hossain
 

Viewers also liked (20)

How to graph in excel
How to graph in excelHow to graph in excel
How to graph in excel
ilanasaxe
 
20160727 - How to Create a Stacked-Cluster Graph in Excel
20160727 - How to Create a Stacked-Cluster Graph in Excel20160727 - How to Create a Stacked-Cluster Graph in Excel
20160727 - How to Create a Stacked-Cluster Graph in Excel
Zaid Kadwa
 
How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007
nfasano
 
Excel Graph Steps
Excel Graph StepsExcel Graph Steps
Excel Graph Steps
Alissa Blatchford
 
Types of graphs
Types of graphsTypes of graphs
Types of graphs
bweldon
 
Graphs ppt
Graphs pptGraphs ppt
Graphs ppt
aimorales
 
MS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATIONMS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATION
Mridul Bansal
 
Configurations Made Easy - Excel Design Tables
Configurations Made Easy - Excel Design TablesConfigurations Made Easy - Excel Design Tables
Configurations Made Easy - Excel Design Tables
CAPINC
 
Operaciones Básicas Excel 2011
Operaciones Básicas Excel 2011Operaciones Básicas Excel 2011
Operaciones Básicas Excel 2011
cantillo2222
 
Excel - Informatica
Excel - InformaticaExcel - Informatica
Excel - Informatica
Bryan Vasquez
 
Graph project
Graph projectGraph project
Graph project
diazjhhs
 
Excel graphs & charts
Excel graphs & chartsExcel graphs & charts
Excel graphs & charts
jmd197961
 
Chapter9
Chapter9Chapter9
Chapter9
Tracie King
 
Chapter10
Chapter10Chapter10
Chapter10
Tracie King
 
Microsoft excel
Microsoft excelMicrosoft excel
Microsoft excel
Lady Mendez
 
Presentacion De Excel
Presentacion De ExcelPresentacion De Excel
Presentacion De Excel
jsuslima384
 
Pie Chart In Excel
Pie Chart In ExcelPie Chart In Excel
Pie Chart In Excel
dinesh takyar
 
Creating Graphs in Excel
Creating Graphs in ExcelCreating Graphs in Excel
Creating Graphs in Excel
clynnc
 
Charts in excel 2007
Charts in excel 2007Charts in excel 2007
Charts in excel 2007
bloftinsaisd
 
Pie charts
Pie chartsPie charts
Pie charts
Sandra Nicks
 
How to graph in excel
How to graph in excelHow to graph in excel
How to graph in excel
ilanasaxe
 
20160727 - How to Create a Stacked-Cluster Graph in Excel
20160727 - How to Create a Stacked-Cluster Graph in Excel20160727 - How to Create a Stacked-Cluster Graph in Excel
20160727 - How to Create a Stacked-Cluster Graph in Excel
Zaid Kadwa
 
How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007How to Insert a Graph into Microsoft Excel 2007
How to Insert a Graph into Microsoft Excel 2007
nfasano
 
Types of graphs
Types of graphsTypes of graphs
Types of graphs
bweldon
 
MS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATIONMS EXCEL PPT PRESENTATION
MS EXCEL PPT PRESENTATION
Mridul Bansal
 
Configurations Made Easy - Excel Design Tables
Configurations Made Easy - Excel Design TablesConfigurations Made Easy - Excel Design Tables
Configurations Made Easy - Excel Design Tables
CAPINC
 
Operaciones Básicas Excel 2011
Operaciones Básicas Excel 2011Operaciones Básicas Excel 2011
Operaciones Básicas Excel 2011
cantillo2222
 
Graph project
Graph projectGraph project
Graph project
diazjhhs
 
Excel graphs & charts
Excel graphs & chartsExcel graphs & charts
Excel graphs & charts
jmd197961
 
Presentacion De Excel
Presentacion De ExcelPresentacion De Excel
Presentacion De Excel
jsuslima384
 
Creating Graphs in Excel
Creating Graphs in ExcelCreating Graphs in Excel
Creating Graphs in Excel
clynnc
 
Charts in excel 2007
Charts in excel 2007Charts in excel 2007
Charts in excel 2007
bloftinsaisd
 
Ad

Similar to Creating tables and graphs (excel) 2011 2012 (20)

Experiment parts technology2008
Experiment parts technology2008Experiment parts technology2008
Experiment parts technology2008
rylempty
 
Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003
bud_00
 
Excel tips&tricks
Excel tips&tricksExcel tips&tricks
Excel tips&tricks
Joel May
 
PAGE 1Using Microsoft Excel 2010 for Selected Tasks(Thr.docx
PAGE  1Using Microsoft Excel 2010 for Selected Tasks(Thr.docxPAGE  1Using Microsoft Excel 2010 for Selected Tasks(Thr.docx
PAGE 1Using Microsoft Excel 2010 for Selected Tasks(Thr.docx
alfred4lewis58146
 
Using Microsoft Excel4 Charts
Using Microsoft Excel4 ChartsUsing Microsoft Excel4 Charts
Using Microsoft Excel4 Charts
Jack Frost
 
Excel 2003 tutorial 2
Excel 2003 tutorial 2Excel 2003 tutorial 2
Excel 2003 tutorial 2
catacata1976
 
Calc. Practice 3 (1º ESO)
Calc. Practice 3 (1º ESO)Calc. Practice 3 (1º ESO)
Calc. Practice 3 (1º ESO)
jesmope
 
Excel Tutorial
Excel TutorialExcel Tutorial
Excel Tutorial
Jayson Patalinghug
 
Jsk industries private limited,excel presentation
Jsk industries private limited,excel presentationJsk industries private limited,excel presentation
Jsk industries private limited,excel presentation
vimeshpandya
 
LESSON 1.pptx
LESSON 1.pptxLESSON 1.pptx
LESSON 1.pptx
GabOlarte
 
Excel chapter-4
Excel chapter-4Excel chapter-4
Excel chapter-4
OpenCastLabs Consulting
 
Excel Basics.ppt
Excel Basics.pptExcel Basics.ppt
Excel Basics.ppt
Anabel Bagdoc
 
MS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.ppt
MS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.pptMS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.ppt
MS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.ppt
pkm16499
 
excell.pdf
excell.pdfexcell.pdf
excell.pdf
ssuser8f8817
 
Excel 2007 Training 2012 Module 1 (Self Study Materials)
Excel 2007 Training 2012 Module 1 (Self Study Materials)Excel 2007 Training 2012 Module 1 (Self Study Materials)
Excel 2007 Training 2012 Module 1 (Self Study Materials)
Amann Group
 
Illahi bux jagirani
Illahi bux jagiraniIllahi bux jagirani
Illahi bux jagirani
ILLAHI BUX JAGIRANI
 
Top 10 excel tips
Top 10 excel tipsTop 10 excel tips
Top 10 excel tips
Excel Prodigy Training & Consultancy Private Limited
 
MS Excel and Visual Basic Applications.pptx
MS Excel and Visual Basic Applications.pptxMS Excel and Visual Basic Applications.pptx
MS Excel and Visual Basic Applications.pptx
surekha1287
 
UNIT 1 (3).pptx....................................
UNIT 1 (3).pptx....................................UNIT 1 (3).pptx....................................
UNIT 1 (3).pptx....................................
vijayannamratha
 
Lesson 5 Basic Tutorial Data Analysis Software for Flow Cytometry
Lesson 5 Basic Tutorial Data Analysis Software for Flow CytometryLesson 5 Basic Tutorial Data Analysis Software for Flow Cytometry
Lesson 5 Basic Tutorial Data Analysis Software for Flow Cytometry
Uttam Belbase
 
Experiment parts technology2008
Experiment parts technology2008Experiment parts technology2008
Experiment parts technology2008
rylempty
 
Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003Creating & Editing Charts In Microsoft Excel 2003
Creating & Editing Charts In Microsoft Excel 2003
bud_00
 
Excel tips&tricks
Excel tips&tricksExcel tips&tricks
Excel tips&tricks
Joel May
 
PAGE 1Using Microsoft Excel 2010 for Selected Tasks(Thr.docx
PAGE  1Using Microsoft Excel 2010 for Selected Tasks(Thr.docxPAGE  1Using Microsoft Excel 2010 for Selected Tasks(Thr.docx
PAGE 1Using Microsoft Excel 2010 for Selected Tasks(Thr.docx
alfred4lewis58146
 
Using Microsoft Excel4 Charts
Using Microsoft Excel4 ChartsUsing Microsoft Excel4 Charts
Using Microsoft Excel4 Charts
Jack Frost
 
Excel 2003 tutorial 2
Excel 2003 tutorial 2Excel 2003 tutorial 2
Excel 2003 tutorial 2
catacata1976
 
Calc. Practice 3 (1º ESO)
Calc. Practice 3 (1º ESO)Calc. Practice 3 (1º ESO)
Calc. Practice 3 (1º ESO)
jesmope
 
Jsk industries private limited,excel presentation
Jsk industries private limited,excel presentationJsk industries private limited,excel presentation
Jsk industries private limited,excel presentation
vimeshpandya
 
LESSON 1.pptx
LESSON 1.pptxLESSON 1.pptx
LESSON 1.pptx
GabOlarte
 
MS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.ppt
MS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.pptMS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.ppt
MS EXCEL INTRODUCTION DISCUSSING ALL FEATURES.ppt
pkm16499
 
Excel 2007 Training 2012 Module 1 (Self Study Materials)
Excel 2007 Training 2012 Module 1 (Self Study Materials)Excel 2007 Training 2012 Module 1 (Self Study Materials)
Excel 2007 Training 2012 Module 1 (Self Study Materials)
Amann Group
 
MS Excel and Visual Basic Applications.pptx
MS Excel and Visual Basic Applications.pptxMS Excel and Visual Basic Applications.pptx
MS Excel and Visual Basic Applications.pptx
surekha1287
 
UNIT 1 (3).pptx....................................
UNIT 1 (3).pptx....................................UNIT 1 (3).pptx....................................
UNIT 1 (3).pptx....................................
vijayannamratha
 
Lesson 5 Basic Tutorial Data Analysis Software for Flow Cytometry
Lesson 5 Basic Tutorial Data Analysis Software for Flow CytometryLesson 5 Basic Tutorial Data Analysis Software for Flow Cytometry
Lesson 5 Basic Tutorial Data Analysis Software for Flow Cytometry
Uttam Belbase
 
Ad

More from giordepasamba (20)

Guide to organizing data and writing the conclusion 2012
Guide to organizing data and writing the conclusion 2012Guide to organizing data and writing the conclusion 2012
Guide to organizing data and writing the conclusion 2012
giordepasamba
 
Heart Dissection Pictures: Block B and G
Heart Dissection Pictures: Block B and GHeart Dissection Pictures: Block B and G
Heart Dissection Pictures: Block B and G
giordepasamba
 
Dna millionaire review2
Dna millionaire review2Dna millionaire review2
Dna millionaire review2
giordepasamba
 
Dna millionaire review
Dna millionaire reviewDna millionaire review
Dna millionaire review
giordepasamba
 
Notes on Mutation
Notes on MutationNotes on Mutation
Notes on Mutation
giordepasamba
 
Breaking the-code-story-of-DNA
Breaking the-code-story-of-DNA Breaking the-code-story-of-DNA
Breaking the-code-story-of-DNA
giordepasamba
 
Revision activity millionaire's game
Revision activity millionaire's gameRevision activity millionaire's game
Revision activity millionaire's game
giordepasamba
 
Notes on DNA
Notes on DNANotes on DNA
Notes on DNA
giordepasamba
 
Scientific drawings
Scientific drawingsScientific drawings
Scientific drawings
giordepasamba
 
Crime scene pictures
Crime scene picturesCrime scene pictures
Crime scene pictures
giordepasamba
 
Performance task- The ecolumn
Performance task-  The ecolumnPerformance task-  The ecolumn
Performance task- The ecolumn
giordepasamba
 
Ecology notes 2 biotic components
Ecology notes 2  biotic componentsEcology notes 2  biotic components
Ecology notes 2 biotic components
giordepasamba
 
Ecology notes 1 ecosystem
Ecology notes 1  ecosystemEcology notes 1  ecosystem
Ecology notes 1 ecosystem
giordepasamba
 
Weather patterns
Weather patternsWeather patterns
Weather patterns
giordepasamba
 
Air pressure and weather
Air pressure and weatherAir pressure and weather
Air pressure and weather
giordepasamba
 
Scientific chef performance task
Scientific chef  performance taskScientific chef  performance task
Scientific chef performance task
giordepasamba
 
Law of conservation of mass
Law of conservation of massLaw of conservation of mass
Law of conservation of mass
giordepasamba
 
Pressure circus notes
Pressure circus  notesPressure circus  notes
Pressure circus notes
giordepasamba
 
Summary physical changes
Summary physical changesSummary physical changes
Summary physical changes
giordepasamba
 
Guide to organizing data and writing the conclusion 2012
Guide to organizing data and writing the conclusion 2012Guide to organizing data and writing the conclusion 2012
Guide to organizing data and writing the conclusion 2012
giordepasamba
 
Heart Dissection Pictures: Block B and G
Heart Dissection Pictures: Block B and GHeart Dissection Pictures: Block B and G
Heart Dissection Pictures: Block B and G
giordepasamba
 
Dna millionaire review2
Dna millionaire review2Dna millionaire review2
Dna millionaire review2
giordepasamba
 
Dna millionaire review
Dna millionaire reviewDna millionaire review
Dna millionaire review
giordepasamba
 
Breaking the-code-story-of-DNA
Breaking the-code-story-of-DNA Breaking the-code-story-of-DNA
Breaking the-code-story-of-DNA
giordepasamba
 
Revision activity millionaire's game
Revision activity millionaire's gameRevision activity millionaire's game
Revision activity millionaire's game
giordepasamba
 
Crime scene pictures
Crime scene picturesCrime scene pictures
Crime scene pictures
giordepasamba
 
Performance task- The ecolumn
Performance task-  The ecolumnPerformance task-  The ecolumn
Performance task- The ecolumn
giordepasamba
 
Ecology notes 2 biotic components
Ecology notes 2  biotic componentsEcology notes 2  biotic components
Ecology notes 2 biotic components
giordepasamba
 
Ecology notes 1 ecosystem
Ecology notes 1  ecosystemEcology notes 1  ecosystem
Ecology notes 1 ecosystem
giordepasamba
 
Air pressure and weather
Air pressure and weatherAir pressure and weather
Air pressure and weather
giordepasamba
 
Scientific chef performance task
Scientific chef  performance taskScientific chef  performance task
Scientific chef performance task
giordepasamba
 
Law of conservation of mass
Law of conservation of massLaw of conservation of mass
Law of conservation of mass
giordepasamba
 
Pressure circus notes
Pressure circus  notesPressure circus  notes
Pressure circus notes
giordepasamba
 
Summary physical changes
Summary physical changesSummary physical changes
Summary physical changes
giordepasamba
 

Recently uploaded (20)

Search Matching Applicants in Odoo 18 - Odoo Slides
Search Matching Applicants in Odoo 18 - Odoo SlidesSearch Matching Applicants in Odoo 18 - Odoo Slides
Search Matching Applicants in Odoo 18 - Odoo Slides
Celine George
 
antiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidenceantiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidence
PrachiSontakke5
 
Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...
Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...
Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...
parmarjuli1412
 
spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)
Mohamed Rizk Khodair
 
BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...
BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...
BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...
Nguyen Thanh Tu Collection
 
How to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo SlidesHow to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo Slides
Celine George
 
Rebuilding the library community in a post-Twitter world
Rebuilding the library community in a post-Twitter worldRebuilding the library community in a post-Twitter world
Rebuilding the library community in a post-Twitter world
Ned Potter
 
Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...
parmarjuli1412
 
Botany Assignment Help Guide - Academic Excellence
Botany Assignment Help Guide - Academic ExcellenceBotany Assignment Help Guide - Academic Excellence
Botany Assignment Help Guide - Academic Excellence
online college homework help
 
How to Add Button in Chatter in Odoo 18 - Odoo Slides
How to Add Button in Chatter in Odoo 18 - Odoo SlidesHow to Add Button in Chatter in Odoo 18 - Odoo Slides
How to Add Button in Chatter in Odoo 18 - Odoo Slides
Celine George
 
MCQS (EMERGENCY NURSING) DR. NASIR MUSTAFA
MCQS (EMERGENCY NURSING) DR. NASIR MUSTAFAMCQS (EMERGENCY NURSING) DR. NASIR MUSTAFA
MCQS (EMERGENCY NURSING) DR. NASIR MUSTAFA
Dr. Nasir Mustafa
 
How to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 PurchaseHow to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 Purchase
Celine George
 
PUBH1000 Slides - Module 11: Governance for Health
PUBH1000 Slides - Module 11: Governance for HealthPUBH1000 Slides - Module 11: Governance for Health
PUBH1000 Slides - Module 11: Governance for Health
JonathanHallett4
 
E-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26ASE-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26AS
Abinash Palangdar
 
How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18
Celine George
 
The History of Kashmir Karkota Dynasty NEP.pptx
The History of Kashmir Karkota Dynasty NEP.pptxThe History of Kashmir Karkota Dynasty NEP.pptx
The History of Kashmir Karkota Dynasty NEP.pptx
Arya Mahila P. G. College, Banaras Hindu University, Varanasi, India.
 
Myasthenia gravis (Neuromuscular disorder)
Myasthenia gravis (Neuromuscular disorder)Myasthenia gravis (Neuromuscular disorder)
Myasthenia gravis (Neuromuscular disorder)
Mohamed Rizk Khodair
 
libbys peer assesment.docx..............
libbys peer assesment.docx..............libbys peer assesment.docx..............
libbys peer assesment.docx..............
19lburrell
 
"Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho...
"Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho..."Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho...
"Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho...
ruslana1975
 
Search Matching Applicants in Odoo 18 - Odoo Slides
Search Matching Applicants in Odoo 18 - Odoo SlidesSearch Matching Applicants in Odoo 18 - Odoo Slides
Search Matching Applicants in Odoo 18 - Odoo Slides
Celine George
 
antiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidenceantiquity of writing in ancient India- literary & archaeological evidence
antiquity of writing in ancient India- literary & archaeological evidence
PrachiSontakke5
 
Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...
Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...
Mental Health Assessment in 5th semester bsc. nursing and also used in 2nd ye...
parmarjuli1412
 
spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)
Mohamed Rizk Khodair
 
BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...
BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...
BÀI TẬP BỔ TRỢ TIẾNG ANH 9 THEO ĐƠN VỊ BÀI HỌC - GLOBAL SUCCESS - CẢ NĂM (TỪ...
Nguyen Thanh Tu Collection
 
How to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo SlidesHow to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo Slides
Celine George
 
Rebuilding the library community in a post-Twitter world
Rebuilding the library community in a post-Twitter worldRebuilding the library community in a post-Twitter world
Rebuilding the library community in a post-Twitter world
Ned Potter
 
Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...
parmarjuli1412
 
Botany Assignment Help Guide - Academic Excellence
Botany Assignment Help Guide - Academic ExcellenceBotany Assignment Help Guide - Academic Excellence
Botany Assignment Help Guide - Academic Excellence
online college homework help
 
How to Add Button in Chatter in Odoo 18 - Odoo Slides
How to Add Button in Chatter in Odoo 18 - Odoo SlidesHow to Add Button in Chatter in Odoo 18 - Odoo Slides
How to Add Button in Chatter in Odoo 18 - Odoo Slides
Celine George
 
MCQS (EMERGENCY NURSING) DR. NASIR MUSTAFA
MCQS (EMERGENCY NURSING) DR. NASIR MUSTAFAMCQS (EMERGENCY NURSING) DR. NASIR MUSTAFA
MCQS (EMERGENCY NURSING) DR. NASIR MUSTAFA
Dr. Nasir Mustafa
 
How to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 PurchaseHow to Manage Amounts in Local Currency in Odoo 18 Purchase
How to Manage Amounts in Local Currency in Odoo 18 Purchase
Celine George
 
PUBH1000 Slides - Module 11: Governance for Health
PUBH1000 Slides - Module 11: Governance for HealthPUBH1000 Slides - Module 11: Governance for Health
PUBH1000 Slides - Module 11: Governance for Health
JonathanHallett4
 
E-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26ASE-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26AS
Abinash Palangdar
 
How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18
Celine George
 
Myasthenia gravis (Neuromuscular disorder)
Myasthenia gravis (Neuromuscular disorder)Myasthenia gravis (Neuromuscular disorder)
Myasthenia gravis (Neuromuscular disorder)
Mohamed Rizk Khodair
 
libbys peer assesment.docx..............
libbys peer assesment.docx..............libbys peer assesment.docx..............
libbys peer assesment.docx..............
19lburrell
 
"Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho...
"Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho..."Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho...
"Heraldry Detective Project"- Coats of Arms and Mottos of "Ivanhoe" in Ivanho...
ruslana1975
 

Creating tables and graphs (excel) 2011 2012

  • 2. Create a table using Excel: 1. Open new document (Excel). 2. Type Title (A1). 3. Input values for independent variable (mass, angle, length) in column A2. 4. Label columns (Time Period) for the 3 trials (Time 1, Time, 2, Time 3). 5. Enter values for all trials. 6. Set formula to get average of 3 trials. Type: =average(then highlight data-B3:D#) Tips: 1. Merging Cells Right click  Format cell alignment  merge 2. Fixing average values Right click  Format cells 7. Copy and Paste other cells  number  Select 2 8. Edit table (center, justify, etc). decimal places 9. Set Borders
  • 3. Create a graph using Excel: 1. Select and drag down first column (independent variable)  click control key  select and drag down average Time period column 2. Click Insert  Select chart  Choose XY scatter . 3. Click Chart Layout  Select Layout 10 4. Click Axis Title, label X and Y axis 5. To delete background, left double click, select delete. 6. Save graph or paste in a Word document. 7. Add appropriate title to graph.
  • 4. Using the graph to predict swing height: 1. Right click on any data point in the graph  Select Add Trend line  Select Power. 2. Making projections: (target- 2.8 sec) Backward forecast: enter number lower than shortest length (9.99- this shows curve of line from 0) Forward forecast: Right click on trend line  Format trend line  Options  Forward  enter 50 or higher 3. Finding 2.8 sec (Time Period): Left Double click anywhere on scale  Format axis  Scale  Change major unit (5 or 10) for X axis Change major unit for Y axis (0.2) 4. Mark predicted length based on a 2.8 Time Period.
  翻译: