Muutke küpsiste eelistusi

E-raamat: Applied Statistics for Business and Management using Microsoft Excel

  • Formaat: PDF+DRM
  • Ilmumisaeg: 26-Nov-2013
  • Kirjastus: Springer-Verlag New York Inc.
  • Keel: eng
  • ISBN-13: 9781461484233
  • Formaat - PDF+DRM
  • Hind: 110,53 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: PDF+DRM
  • Ilmumisaeg: 26-Nov-2013
  • Kirjastus: Springer-Verlag New York Inc.
  • Keel: eng
  • ISBN-13: 9781461484233

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Applied Business Statistics for Business and Management using Microsoft Excel is the first book to illustrate the capabilities of Microsoft Excel to teach applied statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical statistical problems in industry. If understanding statistics isnt your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Applied Business Statistics for Business and Management capitalizes on these improvements by teaching students and practitioners how to apply Excel to statistical techniques necessary in their courses and workplace. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions.
1 Data and Statistics
Key Concepts
2(1)
Discussion
3(2)
Common Pitfalls
5(1)
Final Thoughts and Activities
6(1)
Practice Problems
6(1)
Discussion Boards
6(1)
Group Activity
6(1)
Parting Thought
7(1)
Problem Solutions
7(4)
2 Introduction to Excel and Basic Charts
11(36)
Key Concepts
11(1)
Discussion
11(1)
Basic Concepts
12(13)
Bar and Column Charts
25(2)
Pie Charts
27(3)
Line Charts and Area Charts
30(2)
Other Charts
32(5)
Pivot Tables (Aka Crosstabs)
37(5)
Excel
42(1)
Common Pitfalls
42(1)
Final Thoughts and Activities
42(1)
Practice Problems
42(1)
Discussion Boards
43(1)
Group Activity
43(1)
Parting Thought
43(1)
Problem Solutions
43(4)
3 Summarizing Data: Descriptive Statistics and Histograms
47(32)
Key Concepts
47(1)
Discussion
47(3)
Symbols
50(1)
The Histogram
50(1)
Excel
50(1)
Descriptive Statistics
50(7)
Histograms
57(15)
Common Pitfalls
72(3)
Final Thoughts and Activities
75(1)
Practice Problems
75(1)
Discussion Boards
76(1)
Group Activity
76(1)
Parting Thought
76(1)
Problem Solutions
77(2)
4 Normal Distributions
79(38)
Key Concepts
79(1)
Discussion
79(3)
Excel
82(31)
Common Pitfalls
113(1)
Final Thoughts and Activities
113(1)
Practice Problems
113(1)
Discussion Boards
113(1)
Group Activity
114(1)
Parting Thought
114(1)
Problem Solutions
114(3)
5 Survey Design
117(26)
Key Concepts
119(1)
Discussion
120(1)
Basic Concepts
120(1)
Survey Design
120(1)
Scale
121(2)
Types of Questions
123(4)
Data
127(3)
Coding
130(1)
Errors in Survey Question Creation
131(2)
Errors in Survey Data Collection
133(2)
Checklist
135(1)
Excel
135(4)
Final Thoughts and Activities
139(1)
Practice Problems and Case Studies
139(1)
Discussion Boards
140(1)
Group Activity
140(1)
Parting Thought
140(1)
Problem Solutions
141(2)
6 Sampling
143(18)
Key Concepts
145(1)
Discussion
146(2)
Types of Problems
148(2)
Excel
150(1)
Problem Type: Infinite Mean
150(2)
Practice Problem for Infinite Mean
152(1)
Problem Type: Infinite Proportion
153(2)
Practice Problem for Infinite Proportion
155(1)
Finite Population Correction Factor (fpc)
156(1)
Final Thoughts and Activities
157(1)
Practice Problems
157(1)
Discussion Boards
157(1)
Group Activity
157(1)
Parting Thought
158(1)
Problem Solutions
158(3)
7 Inference
161(22)
Key Concepts
161(1)
Discussion
161(4)
Inferring Proportions
165(1)
Example Problem
165(1)
Excel
165(4)
Inferring Averages
169(1)
Example Problem
169(1)
Excel
169(2)
Confidence Intervals with Proportion Inference
171(1)
Example Problem
171(1)
Excel
171(7)
Final Thoughts and Activities
178(1)
Practice Problems and Case Studies
178(1)
Discussion Boards
178(1)
Group Activity
179(1)
Parting Thought
179(1)
Problem Solutions
179(4)
8 Probability
183(22)
Key Concepts
183(1)
Discussion
183(3)
Example 1
186(1)
Example 2
187(2)
Excel
189(1)
Finding Probabilities Using Normal Distributions
189(6)
Calculating Combinations and Permutations
195(4)
Finding Probabilities Using the Binomial Distribution
199(2)
Common Excel Pitfalls
201(1)
Final Thoughts and Activities
202(1)
Practice Problems
202(1)
Discussion Boards
202(1)
Group Activity
203(1)
Parting Thought
203(1)
Problem Solutions
203(2)
9 Correlation
205(16)
Key Concepts
205(1)
Discussion
205(4)
Nonlinear data caution
209(1)
Average data caution
210(1)
Excel
210(1)
Correlation: One r Value or Correlation Matrix
210(5)
Common Excel Pitfalls
215(1)
Final Thoughts and Activities
215(1)
Practice Problems
215(1)
Discussion Boards
216(1)
Group Activity
216(1)
Parting Thought
217(1)
Problem Solutions
217(4)
10 Simple Linear Regression
221(28)
Key Concepts
221(1)
Discussion
221(5)
Residuals and Tests for Linearity
226(2)
Standardized Residuals and Outliers
228(1)
Excel
229(1)
Scatterplot: Compute the Regression Line and the Coefficient of Determination
230(4)
Regression Function: Compute the Regression Model
234(2)
Compute Residual Plots Using the Regression Function
236(2)
Using Excel's Regression Tool to Test for Normality of the Distribution of Residuals
238(1)
Using Excel's Regression Tool to Test for Constant Variance of Residuals
239(2)
Summary of Regression Analysis Process
241(1)
Common Excel Pitfalls
242(1)
Final Thoughts and Activities
242(1)
Practice Problems
242(1)
Discussion Boards
243(1)
Group Activities
243(1)
Parting Thought
244(1)
Problem Solutions
244(5)
11 Significance Tests Part 1
249(60)
Key Concepts
249(1)
Discussion
249(1)
Basic Concepts
250(7)
Significance Tests
257(1)
F-test
258(25)
t-Test
283(19)
Common Excel Pitfalls
302(1)
Final Thoughts and Activities
302(1)
Practice Problems and Case Studies
302(1)
Discussion Boards
303(1)
Group Activity
303(1)
Parting Thought
303(1)
Problem Solutions
304(5)
12 Significance Tests Part 2
309(46)
Key Concepts
309(1)
Discussion
309(1)
Significance Tests
309(1)
X2 Test
310(11)
z-Test
321(22)
Common Excel Pitfalls
343(1)
Final Thoughts and Activities
343(1)
Practice Problems and Case Studies
343(2)
Discussion Boards
345(1)
Group Activity
345(1)
Parting Thought
345(1)
Problem Solutions
345(10)
13 Multiple Regression
355(16)
Key Concepts
355(1)
Discussion
355(3)
Excel
358(7)
Step 1 Fit the Model with Selected Independent Variables
358(1)
Step 2 Does Multicollinearity Exist? Run a Correlation Matrix
358(3)
Step 3 Run Regression Model
361(2)
Step 4 Are the Assumptions of Regression Satisfied?
363(1)
Step 5 Test Overall Model Significance (F-Test)
364(1)
Step 6 Check p-Values for Independent Variables Meet Significance Criteria (t-Test)
364(1)
Step 7 Run Model for Prediction and Estimation
364(1)
Run Regression Model
365(1)
Final Thoughts and Activities
366(1)
Practice Problems
366(1)
Discussion Boards
367(1)
Parting Thought
367(1)
Problem Solutions
367(4)
14 Non-linear Regression
371(20)
Key Concepts
371(1)
Discussion
371(1)
Power
371(1)
Polynomial
372(1)
Exponential
373(1)
Logarithmic
374(1)
Excel
375(1)
Create the Trendline Graphs
376(5)
Using the Non-linear Regression Trendline for Prediction
381(3)
Common Excel Pitfalls
384(1)
Final Thoughts and Activities
385(1)
Practice Problems and Case Studies
385(1)
Discussion Boards
386(1)
Group Activity
386(1)
Parting Thought
387(1)
Problem Solutions
387(4)
15 Survey Reports
391(23)
Key Concepts
394(1)
Discussion
395(5)
Useful Hints and Phrases for the Report
400(1)
Effective PowerPoint Presentations with Excel
400(1)
Executive Summary
401(1)
Methodology
402(1)
Sampling Plan and Survey Creation
402(1)
Results
403(4)
Conclusions and Recommendations
407(1)
Final Thoughts and Activities
408(1)
Practice Problems and Case Studies
408(2)
Discussion Boards
410(1)
Group Activity
410(1)
Parting Thought
410(1)
Problem Solutions
410(1)
Executive Summary
411(1)
Background and Objectives
411(1)
Research Methodology
412(1)
Overview of Results
412(1)
Conclusions and Recommendations
413(1)
Bibliography 414(1)
Appendix 1 414(1)
Index 415
Linda Herkenhoff is currently a full professor and director of the Transglobal MBA program at Saint Marys College in Moraga, California, where she teaches Quantitative Analysis and Statistics. She is the former Executive Director of Human Resources for Stanford University. The first sixteen years of her career included various responsibilities within Chevron Corporation, primarily as a geophysicist. She has lived/worked/conducted research in over 30 countries and has spent time on all 7 continents.

 

John Fogli is the Founder and President of Sentenium, Inc.  John's business research methods have helped public and private industries better understand the involvement necessary to lead consensus solutions. He has facilitated over 500 survey projects in the areas of consumer, employee, political, and operation(s) research. He is a member of the Market Research Association and holds a Professional Research Certificate. He is currently a part-time faculty member with the Department of Business at Diablo Valley College and sits on the Executive Council for The Pacific Chapter of American Association for Public Opinion Research. He earned his B.S. from University of California, Berkeley and an MBA from the University of San Francisco.