Skip to main content Accessibility help

We use cookies to distinguish you from other users and to provide you with a better experience on our websites. Close this message to accept cookies or find out how to manage your cookie settings.

Close cookie message
×
Hostname: page-component-77c89778f8-m42fx Total loading time: 0 Render date: 2024-07-18T13:40:11.347Z Has data issue: false hasContentIssue false

Chapter 3 - Software

Excel, Microsoft Mathematics, and JASP

Published online by Cambridge University Press:  13 July 2023

Ramalingam Shanmugam
Ramalingam Shanmugam
Affiliation:
Texas State University, San Marcos
Get access

Summary

This chapter examines three software programs that assist users to compute the necessary quantities, make summaries, construct graphical displays – including charts – from data, and create two- and three-dimensional pictures from expressions or numbers.

Microsoft Excel is a module of the Microsoft Office suite of software programs (www.microsoft.com/en-us/download). Excel is composed of several subroutines, Excel commands, through which users can perform calculations. JASP, now in the public domain (https://jasp-stats.org), was created and is supported by the University of Amsterdam in the Netherlands. Input data for analysis by JASP need to be entered in an Excel spreadsheet, saved as a comma-delimited (.CSV) file, and fed to JASP software. Microsoft Math Solver, developed and maintained by the Microsoft Corporation, is free to download. It allows users to solve math and science problems. It was developed and maintained by the Microsoft Corporation.

Type
Chapter
Information
Data-Guided Healthcare Decision Making , pp. 55 - 90
Publisher: Cambridge University Press
Print publication year: 2023

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

References

Selected References

Arsham, H. (2011). Excel for statistical data analysis. http://home.ubalt.edu/ntsbarsh/Business-stat/excel/excel.htm.Google Scholar
Ayer, G. (2016) Excel. Energy Engineering, 113(2), 63–74.CrossRefGoogle Scholar
Baier, T., & Neuwirth, E. (2007). Excel COM. Computational Statistics, 22(1), 91–108.CrossRefGoogle Scholar
Bartlett, J. (2017). An introduction to JASP: a free and user-friendly statistics package. https://osf.io/p2hzg.Google Scholar
Berk, K., & Carey, P. (2009). Data Analysis with Microsoft Excel: Updated for Office 2007. Scarborough, Canada: Nelson Education.Google Scholar
Bluttman, K. (2013). Excel Formulas and Functions for Dummies. Hoboken, NJ: Wiley.Google Scholar
Broman, K. W., & Woo, K. H. (2018). Data organization in spreadsheets. American Statistician, 72(1), 2–10.Google Scholar
Chandrakantha, L. (2014). Excel simulation as a tool in teaching sampling distributions in introductory statistics. In Sustainability in Statistics Education: Proceedings of the Ninth International Conference on Teaching Statistics (ICOTS), edited by Makar, K., De Sousa, B., & Gould, R. (pp. 1–3). New York: International Statistical Institute.Google Scholar
Frye, C. (2010). Microsoft Excel 2010 Step by Step: MS Excel 2010 SbS _p1. Hoboken, NJ: Pearson Education.Google Scholar
Fylstra, D., Lasdon, L., Watson, J., & Waren, A. (1998). Design and use of the Microsoft Excel Solver. Interfaces, 28(5), 29–55.Google Scholar
Halpern, A. M., Frye, S. L., & Marzzacco, C. J. (2018). Scientific Data Analysis Toolkit: A Versatile Add-In to Microsoft Excel for Windows. Hoboken, NJ: Pearson Education.Google Scholar
Halter, C. P. (2018). Exploring Statistical Analysis Using JASP. Independently published.Google Scholar
Han, H., & Dawson, K. J. (2020). JASP (Software). Mark Harmon.Google Scholar
Harmon, M. (2011). Normality Testing in Excel: The Excel Statistical Master. Mark Harmon. www.ExcelMasterSeries.com.Google Scholar
Heiberger, R. M., & Neuwirth, E. (2010). R through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics. New York: Springer Science & Business Media.Google Scholar
Jeschke, E., Reinke, H., Unverhau, S., & Pfeifer, E. (2011). Microsoft Excel 2010 Formulas and Functions Inside Out. Hoboken, NJ: Pearson Education.Google Scholar
Kelter, R. (2020). Bayesian alternatives to null hypothesis significance testing in biomedical research: a non-technical introduction to Bayesian inference with JASP. BMC Medical Research Methodology, 20, 1–12.CrossRefGoogle ScholarPubMed
Love, J., Selker, R., Marsman, M. et al. (2019). JASP: graphical statistical software for common statistical designs. Journal of Statistical Software, 88(2), 1–17.Google Scholar
Quintela-del-Río, A., & Francisco-Fernández, M. (2017). Excel templates: a helpful tool for teaching statistics. American Statistician, 71(4), 317–325.CrossRefGoogle Scholar
Quirk, T. J. (2020). Excel 2019 for Engineering Statistics. Berlin: Springer International.Google Scholar
Quirk, T. J., & Cummings, S. (2016). Excel 2016 for Health Services Management Statistics. Berlin: Springer.Google Scholar
Schou, S. B. (1999). Data, statistics, and decision models with Excel. American Statistician, 53(4), 389.CrossRefGoogle Scholar
Van Doorn, J., Van den Bergh, D., Böhm, U. et al. (2020). The JASP guidelines for conducting and reporting a Bayesian analysis. Psychonomic Bulletin & Review, 28(3), 813–826.CrossRefGoogle Scholar
Veney, J. E., Kros, J. F., & Rosenthal, D. A. (2009). Statistics for Health Care Professionals: Working with Excel (Vol. 9). Hoboken, NJ: Wiley.Google Scholar
Wagenmakers, E. J., Love, J., Marsman, M. et al. (2018). Bayesian inference for psychology. Part II: example applications with JASP. Psychonomic Bulletin & Review, 25(1), 58–76.CrossRefGoogle ScholarPubMed
Walkenbach, J. (2010). Excel 2010 Power Programming with VBA (Vol. 6). New York: Hoboken, NJ: Wiley.CrossRefGoogle Scholar

Save book to Kindle

To save this book to your Kindle, first ensure coreplatform@cambridge.org is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.

Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.

Find out more about the Kindle Personal Document Service.

  • Software
  • Ramalingam Shanmugam, Texas State University, San Marcos
  • Book: Data-Guided Healthcare Decision Making
  • Online publication: 13 July 2023
  • Chapter DOI: https://doi.org/10.1017/9781009212021.005
Available formats
×

Save book to Dropbox

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.

  • Software
  • Ramalingam Shanmugam, Texas State University, San Marcos
  • Book: Data-Guided Healthcare Decision Making
  • Online publication: 13 July 2023
  • Chapter DOI: https://doi.org/10.1017/9781009212021.005
Available formats
×

Save book to Google Drive

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.

  • Software
  • Ramalingam Shanmugam, Texas State University, San Marcos
  • Book: Data-Guided Healthcare Decision Making
  • Online publication: 13 July 2023
  • Chapter DOI: https://doi.org/10.1017/9781009212021.005
Available formats
×