Excel 2013 for Physical Sciences Statistics: A Guide to Solving Practical Problems
This book shows the is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn’t 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 science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2013 for Physical Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.
Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Random Number Generator
Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing
OneGroup tTest for the Mean
TwoGroup tTest of the Difference of the Means for Independent Groups
Correlation and Simple Linear Regression
Other editions - View all
absolute value accept the research ANOVA t-test comparing Answer see Fig Answer to Chap Brand cell Chapter chart Chevy Impala column compute confidence interval Create an Excel critical value ð Þ Data for Chap degrees of freedom dialog box duplicate frame numbers Excel for Statistics Excel printout Excel skills Excel spreadsheet Excel to find final spreadsheet find the sample FROSH GPA groups Guide to Solving hypothesis and accept hypothetical data Important note International Publishing Switzerland Let’s Mohs scale multiple correlation null hypothesis number format number of gallons one-group t-test population mean predictor Print random numbers regression analysis regression equation regression line reject the null research hypothesis research study result sample mean sample size Save this file scatterplot screen Solving Practical Problems Springer International Publishing Springer Science+Business Media standard deviation standard error statistical test STDEV steps SUMMARY OUTPUT t-table in Appendix T.J. Quirk two-group t-test variables Worksheet Data y-intercept