際際滷

際際滷Share a Scribd company logo
FINDING AREAS FOR Z AND USING Z IN FINDING X GIVEN AREA USING EXCEL


                       FINDING AREAS FOR Z
1.   Click Formulas
2.   Function
3.   Choose NORMDIST
4.   OK
5.   Type the value of x in the X box
6.   Type the value of the mean in the Mean box
7.   Type the value of the standard deviation in the Standard_dev box
8.   In the Cumulative box type true




9. Notice the results are for the area from the far left of the distribution up to X. If you are interested in
   the area between the mean and X, you will need to subtract .500 from the cumulative area.
USING Z IN FINDING X GIVEN AREA USING EXCEL
1.   Click Formulas
2.   Function
3.   Choose NORMINV
4.   OK
5. Type the probability value in the Probability box
6. Type the mean value into the Mean box
7. Type the standard deviation into the Standard_dev box




8. Notice the results are for the area from the far left of the distribution up to X. If you are interested in
   the area between the mean and X, you will need to subtract the cumulative area from .500.

More Related Content

More from Sandra Nicks (20)

Newletter v 2.1
Newletter v 2.1Newletter v 2.1
Newletter v 2.1
Sandra Nicks
Night owl
Night owlNight owl
Night owl
Sandra Nicks
Simple random sample using excel
Simple random sample using excelSimple random sample using excel
Simple random sample using excel
Sandra Nicks
Chap015
Chap015Chap015
Chap015
Sandra Nicks
Chap010
Chap010Chap010
Chap010
Sandra Nicks
Chap009
Chap009Chap009
Chap009
Sandra Nicks
Chap007
Chap007Chap007
Chap007
Sandra Nicks
Calculating binomial probabilities using excel
Calculating binomial probabilities using excelCalculating binomial probabilities using excel
Calculating binomial probabilities using excel
Sandra Nicks
Chap008
Chap008Chap008
Chap008
Sandra Nicks
Chap006
Chap006Chap006
Chap006
Sandra Nicks
Chap004
Chap004Chap004
Chap004
Sandra Nicks
Creating frequency distribution table, histograms and polygons using excel an...
Creating frequency distribution table, histograms and polygons using excel an...Creating frequency distribution table, histograms and polygons using excel an...
Creating frequency distribution table, histograms and polygons using excel an...
Sandra Nicks
Creating frequency distribution tables and histograms using excel analysis to...
Creating frequency distribution tables and histograms using excel analysis to...Creating frequency distribution tables and histograms using excel analysis to...
Creating frequency distribution tables and histograms using excel analysis to...
Sandra Nicks
Chap005
Chap005Chap005
Chap005
Sandra Nicks
Chap003
Chap003Chap003
Chap003
Sandra Nicks
Chap004
Chap004Chap004
Chap004
Sandra Nicks
Chap002
Chap002Chap002
Chap002
Sandra Nicks
Aron chpt 1 ed (1)
Aron chpt 1 ed (1)Aron chpt 1 ed (1)
Aron chpt 1 ed (1)
Sandra Nicks
Aronchpt3correlation
Aronchpt3correlationAronchpt3correlation
Aronchpt3correlation
Sandra Nicks
Calculating a correlation coefficient and scatter plot using excel
Calculating a correlation coefficient and scatter plot using excelCalculating a correlation coefficient and scatter plot using excel
Calculating a correlation coefficient and scatter plot using excel
Sandra Nicks
Newletter v 2.1
Newletter v 2.1Newletter v 2.1
Newletter v 2.1
Sandra Nicks
Simple random sample using excel
Simple random sample using excelSimple random sample using excel
Simple random sample using excel
Sandra Nicks
Calculating binomial probabilities using excel
Calculating binomial probabilities using excelCalculating binomial probabilities using excel
Calculating binomial probabilities using excel
Sandra Nicks
Creating frequency distribution table, histograms and polygons using excel an...
Creating frequency distribution table, histograms and polygons using excel an...Creating frequency distribution table, histograms and polygons using excel an...
Creating frequency distribution table, histograms and polygons using excel an...
Sandra Nicks
Creating frequency distribution tables and histograms using excel analysis to...
Creating frequency distribution tables and histograms using excel analysis to...Creating frequency distribution tables and histograms using excel analysis to...
Creating frequency distribution tables and histograms using excel analysis to...
Sandra Nicks
Aron chpt 1 ed (1)
Aron chpt 1 ed (1)Aron chpt 1 ed (1)
Aron chpt 1 ed (1)
Sandra Nicks
Aronchpt3correlation
Aronchpt3correlationAronchpt3correlation
Aronchpt3correlation
Sandra Nicks
Calculating a correlation coefficient and scatter plot using excel
Calculating a correlation coefficient and scatter plot using excelCalculating a correlation coefficient and scatter plot using excel
Calculating a correlation coefficient and scatter plot using excel
Sandra Nicks

Recently uploaded (20)

compiler design BCS613C question bank 2022 scheme
compiler design BCS613C question bank 2022 schemecompiler design BCS613C question bank 2022 scheme
compiler design BCS613C question bank 2022 scheme
Suvarna Hiremath
DUODENUM ANATOMY & Clinical Anatomy.pptx
DUODENUM ANATOMY & Clinical Anatomy.pptxDUODENUM ANATOMY & Clinical Anatomy.pptx
DUODENUM ANATOMY & Clinical Anatomy.pptx
Sid Roy
Berry_Kanisha_BAS_PB1_202503 (2) (2).pdf
Berry_Kanisha_BAS_PB1_202503 (2) (2).pdfBerry_Kanisha_BAS_PB1_202503 (2) (2).pdf
Berry_Kanisha_BAS_PB1_202503 (2) (2).pdf
KanishaBerry
Karin Clavel - Collection Wall: Inspiring connection and collaboration
Karin Clavel - Collection Wall: Inspiring connection and collaborationKarin Clavel - Collection Wall: Inspiring connection and collaboration
Karin Clavel - Collection Wall: Inspiring connection and collaboration
voginip
Anti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VI
Anti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VIAnti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VI
Anti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VI
Samruddhi Khonde
MIPLM subject matter expert Daniel Holzner
MIPLM subject matter expert Daniel HolznerMIPLM subject matter expert Daniel Holzner
MIPLM subject matter expert Daniel Holzner
MIPLM
Key Frameworks in Systematic Reviews - Dr Reginald Quansah
Key Frameworks in Systematic Reviews - Dr Reginald QuansahKey Frameworks in Systematic Reviews - Dr Reginald Quansah
Key Frameworks in Systematic Reviews - Dr Reginald Quansah
Systematic Reviews Network (SRN)
How to Manage Purchase Order Approval in Odoo 18
How to Manage Purchase Order Approval in Odoo 18How to Manage Purchase Order Approval in Odoo 18
How to Manage Purchase Order Approval in Odoo 18
Celine George
The basics of sentences session 10pptx.pptx
The basics of sentences session 10pptx.pptxThe basics of sentences session 10pptx.pptx
The basics of sentences session 10pptx.pptx
heathfieldcps1
20250402 ACCA TeamScienceAIEra 20250402 v10.pptx
20250402 ACCA TeamScienceAIEra 20250402 v10.pptx20250402 ACCA TeamScienceAIEra 20250402 v10.pptx
20250402 ACCA TeamScienceAIEra 20250402 v10.pptx
home
Unit 3: Combustion in Spark Ignition Engines
Unit 3: Combustion in Spark Ignition EnginesUnit 3: Combustion in Spark Ignition Engines
Unit 3: Combustion in Spark Ignition Engines
NileshKumbhar21
Different perspectives on dugout canoe heritage of Soomaa.pdf
Different perspectives on dugout canoe heritage of Soomaa.pdfDifferent perspectives on dugout canoe heritage of Soomaa.pdf
Different perspectives on dugout canoe heritage of Soomaa.pdf
Aivar Ruukel
Gold Spot Dairy Store Jordan Minnesota 55352
Gold Spot Dairy Store Jordan Minnesota 55352Gold Spot Dairy Store Jordan Minnesota 55352
Gold Spot Dairy Store Jordan Minnesota 55352
Forklift Trucks in Minnesota
Knownsense 2025 prelims- U-25 General Quiz.pdf
Knownsense 2025 prelims- U-25 General Quiz.pdfKnownsense 2025 prelims- U-25 General Quiz.pdf
Knownsense 2025 prelims- U-25 General Quiz.pdf
Pragya - UEM Kolkata Quiz Club
MIPLM subject matter expert Sascha Kamhuber
MIPLM subject matter expert Sascha KamhuberMIPLM subject matter expert Sascha Kamhuber
MIPLM subject matter expert Sascha Kamhuber
MIPLM
MIPLM subject matter expert Dr Robert Klinski
MIPLM subject matter expert Dr Robert KlinskiMIPLM subject matter expert Dr Robert Klinski
MIPLM subject matter expert Dr Robert Klinski
MIPLM
Viceroys of India & Their Tenure Key Events During British Rule
Viceroys of India & Their Tenure  Key Events During British RuleViceroys of India & Their Tenure  Key Events During British Rule
Viceroys of India & Their Tenure Key Events During British Rule
DeeptiKumari61
Studying and Notetaking: Some Suggestions
Studying and Notetaking: Some SuggestionsStudying and Notetaking: Some Suggestions
Studying and Notetaking: Some Suggestions
Damian T. Gordon
Design approaches and ethical challenges in Artificial Intelligence tools for...
Design approaches and ethical challenges in Artificial Intelligence tools for...Design approaches and ethical challenges in Artificial Intelligence tools for...
Design approaches and ethical challenges in Artificial Intelligence tools for...
Yannis
Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ...
 Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ... Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ...
Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ...
coreylewis960
compiler design BCS613C question bank 2022 scheme
compiler design BCS613C question bank 2022 schemecompiler design BCS613C question bank 2022 scheme
compiler design BCS613C question bank 2022 scheme
Suvarna Hiremath
DUODENUM ANATOMY & Clinical Anatomy.pptx
DUODENUM ANATOMY & Clinical Anatomy.pptxDUODENUM ANATOMY & Clinical Anatomy.pptx
DUODENUM ANATOMY & Clinical Anatomy.pptx
Sid Roy
Berry_Kanisha_BAS_PB1_202503 (2) (2).pdf
Berry_Kanisha_BAS_PB1_202503 (2) (2).pdfBerry_Kanisha_BAS_PB1_202503 (2) (2).pdf
Berry_Kanisha_BAS_PB1_202503 (2) (2).pdf
KanishaBerry
Karin Clavel - Collection Wall: Inspiring connection and collaboration
Karin Clavel - Collection Wall: Inspiring connection and collaborationKarin Clavel - Collection Wall: Inspiring connection and collaboration
Karin Clavel - Collection Wall: Inspiring connection and collaboration
voginip
Anti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VI
Anti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VIAnti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VI
Anti-Fungal Agents.pptx Medicinal Chemistry III B. Pharm Sem VI
Samruddhi Khonde
MIPLM subject matter expert Daniel Holzner
MIPLM subject matter expert Daniel HolznerMIPLM subject matter expert Daniel Holzner
MIPLM subject matter expert Daniel Holzner
MIPLM
Key Frameworks in Systematic Reviews - Dr Reginald Quansah
Key Frameworks in Systematic Reviews - Dr Reginald QuansahKey Frameworks in Systematic Reviews - Dr Reginald Quansah
Key Frameworks in Systematic Reviews - Dr Reginald Quansah
Systematic Reviews Network (SRN)
How to Manage Purchase Order Approval in Odoo 18
How to Manage Purchase Order Approval in Odoo 18How to Manage Purchase Order Approval in Odoo 18
How to Manage Purchase Order Approval in Odoo 18
Celine George
The basics of sentences session 10pptx.pptx
The basics of sentences session 10pptx.pptxThe basics of sentences session 10pptx.pptx
The basics of sentences session 10pptx.pptx
heathfieldcps1
20250402 ACCA TeamScienceAIEra 20250402 v10.pptx
20250402 ACCA TeamScienceAIEra 20250402 v10.pptx20250402 ACCA TeamScienceAIEra 20250402 v10.pptx
20250402 ACCA TeamScienceAIEra 20250402 v10.pptx
home
Unit 3: Combustion in Spark Ignition Engines
Unit 3: Combustion in Spark Ignition EnginesUnit 3: Combustion in Spark Ignition Engines
Unit 3: Combustion in Spark Ignition Engines
NileshKumbhar21
Different perspectives on dugout canoe heritage of Soomaa.pdf
Different perspectives on dugout canoe heritage of Soomaa.pdfDifferent perspectives on dugout canoe heritage of Soomaa.pdf
Different perspectives on dugout canoe heritage of Soomaa.pdf
Aivar Ruukel
MIPLM subject matter expert Sascha Kamhuber
MIPLM subject matter expert Sascha KamhuberMIPLM subject matter expert Sascha Kamhuber
MIPLM subject matter expert Sascha Kamhuber
MIPLM
MIPLM subject matter expert Dr Robert Klinski
MIPLM subject matter expert Dr Robert KlinskiMIPLM subject matter expert Dr Robert Klinski
MIPLM subject matter expert Dr Robert Klinski
MIPLM
Viceroys of India & Their Tenure Key Events During British Rule
Viceroys of India & Their Tenure  Key Events During British RuleViceroys of India & Their Tenure  Key Events During British Rule
Viceroys of India & Their Tenure Key Events During British Rule
DeeptiKumari61
Studying and Notetaking: Some Suggestions
Studying and Notetaking: Some SuggestionsStudying and Notetaking: Some Suggestions
Studying and Notetaking: Some Suggestions
Damian T. Gordon
Design approaches and ethical challenges in Artificial Intelligence tools for...
Design approaches and ethical challenges in Artificial Intelligence tools for...Design approaches and ethical challenges in Artificial Intelligence tools for...
Design approaches and ethical challenges in Artificial Intelligence tools for...
Yannis
Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ...
 Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ... Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ...
Marketing is Everything in the Beauty Business! 憓 Talent gets you in the ...
coreylewis960

Finding areas for z using excel

  • 1. FINDING AREAS FOR Z AND USING Z IN FINDING X GIVEN AREA USING EXCEL FINDING AREAS FOR Z 1. Click Formulas 2. Function 3. Choose NORMDIST 4. OK
  • 2. 5. Type the value of x in the X box 6. Type the value of the mean in the Mean box 7. Type the value of the standard deviation in the Standard_dev box 8. In the Cumulative box type true 9. Notice the results are for the area from the far left of the distribution up to X. If you are interested in the area between the mean and X, you will need to subtract .500 from the cumulative area.
  • 3. USING Z IN FINDING X GIVEN AREA USING EXCEL 1. Click Formulas 2. Function 3. Choose NORMINV 4. OK
  • 4. 5. Type the probability value in the Probability box 6. Type the mean value into the Mean box 7. Type the standard deviation into the Standard_dev box 8. Notice the results are for the area from the far left of the distribution up to X. If you are interested in the area between the mean and X, you will need to subtract the cumulative area from .500.