![]() Rob Mason at Olney Central College (Olney, IL) and are used here with his permission. Pleasenote that the department has one accessible Windows PC that mightbe used for demonstration purposes only IF you bring along theproper software and the diskette used is known to be virus free.įamiliarize yourself with the power of Excel in both Physics and Mathematics by working with each of the following four examples: vector analysis, projectile motion, solving simultaneous quadratic equations graphically, and using the bisection method. Any spreadsheet software will do but you need tobe able to demonstrate the working of your spreadsheet. ![]() If you are more facile with another program, you mayuse that to create your spread sheet there is nothing sacredabout Excel. In the long run you'll spend a lot less time on thisproject. PLEASE, for your own sake, work through thetutorial. IMPORTANT NOTICE: Many students choose to skip working throughthe tutorial thinking that it will take no time at all to justbegin working successfully with this software. Additionally,you will use your spreadsheet skills to create a small grade bookprogram. The purpose of this project is two-fold:to provide you with a setting to explore physics that is not constrainedby the need to use advanced mathematics, and to introduce youto a powerful tool for exploring the world of physics. In this project you will learn howto use EXCEL as a tool to explore the behavior of physical phenomena.The nature of these explorations is sufficiently different fromnormal physics problems that you will encounter several surprisesand interesting twists. The word "investigate"is used here to convey the exploratory nature of the activities which you willencounter in this project. Spreadsheets will help you andyour students investigate phenomena in a way that is very differentfrom traditional problem solving. New version supports Excel 2016.Using Excel Spreadsheets in Physics Teachingįor many candidate physics teachers spreadsheets are a newexperience in exploring physics. Its spreadsheet features: reads Microsoft Excel,StatSoft Statistica,SPSS formats, plots charts - histograms, bars, areas, point-graphs, pies, etc Students and academic discounts make this package very affordable - from $60 for just 1 license. StatPlus has powerful data processor (from sampling up to special transformations). Statistical features includes basic statistics (from descriptive statistics and normality tests up to Fechner correlation and frequency tables) variety of ANOVA procedures (MANOVA,GLM, Latin and Greco-latin squares analysis) nonparametric statistics (from contingency tables analysis, chi-square test, rank correlations up to Mann-Whitney U, Kolmogorov-Smirnov, Rosenbaum, Wald-Wolfowitz Runs Tests,Kruskal-Wallis ANOVA, Wilcoxon Test, Sign Test, Friedman ANOVA, Kendall's Concordance and Cochran Q Test) regression procedures like linear, polynomial, logistic, stepwise) survival analysis - probit-analysis, cox regression time series analysis - from smoothing to moving Average, auto correlation, partial AC. This frees up intellectual resources for analyzing the results, rather than agonizing over who and how processed the data, and if any mistakes were made in the process. While StatPlus is a "heavy-duty" professional statistical analysis tool, the interface is so simple that even people who have no knowledge of statistics are capable of processing data, provided they know how to use PC and clear instructions are given. The range of possible applications of StatPlusis virtually unlimited - sociology, financial analysis, biostatistics, economics, insurance industry, healthcare and clinical research, probability calculations for lotteries and gambling operations - to name just a few fields where the program is already being extensively used. With StatPlus, one gets a robust suite of statistics tools and graphical analysis methods that are easily accessed though a simple and straightforward interface.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |