1 / 21

Aplikasi Komputer Matematika I

Learn about Excel's range operations, formulas, and statistical functions such as Average, Median, Mode, and more. Discover essential techniques to improve data analysis skills in Excel. Get started now!

ndavis
Download Presentation

Aplikasi Komputer Matematika I

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AplikasiKomputer MatematikaI By: Anesia noviliza, S.pdi, M.a

  2. Microsoft ExcelPart I :An Intro

  3. The use of M. Excel

  4. Let’s get it started!! • 1. Range: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations. • 2. Formulas and Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. • 3. Statistical Functions : Average | Averageif | Median | Mode | Standard Deviation | Min | Max | Large | Small

  5. Range

  6. Formulas and Functions • Subtract, Simply use the minus sign (-). Don't forget, always start a formula with an equal sign (=). • Multiply, Simply use the asterisk symbol (*) as the multiplication operator • Divide, Use the forward slash (/) as the division operator • Square Root, First, to square a number, multiply the number by itself. For example, 4 * 4 = 16 or 4^2 = 16 • Percentage, First, enter a decimal number and On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format

  7. Statistical Function Average | Averageif | Median | Mode | Standard Deviation | Min | Max |

  8. AverageTo calculate the average of a group of numbers, use the AVERAGE function

  9. AverageifTo average cells based on one criteria, use the AVERAGEIF function. For example, to calculate the average excluding zeros

  10. MedianTo find the median (or middle number), use the MEDIAN functionn

  11. ModeTo find the most frequently occurring number, use the MODE function

  12. Standard DeviationStandard deviation is a number that tells you how far numbers are from their mean

  13. MinTo find the minimum value, use the MIN function

  14. MaxTo find the maximum value, use the MAX function

  15. Source and study more at : https://www.excel-easy.com/

  16. Do it Now Analisis data deskriptifdari data Nlai Matematika Siswadisamping

  17. Ppt Hari ini bisa di download di:anespunya.wordpress.com/UMSB

  18. Shortcut ^.~ M.Excel punya menu lengkap analisisDescriptif Statistic. Contohnya kalo kamu punya data di samping! Langkah-langkah yang bisa dilakukan: • Pada data tab analysis grup, click data analysis 2. Pilih Descriptive statistic dan click OK

  19. Lanjutan,… 3. Pilih A2:A15 sebagai Input Range 4. Pilih Cell C1 sebagai Output Range 5. Pastikan Summary Statistic sudah di tandai (check)

  20. Lanjutan,… 6. Klik OK Hasilnya

  21. Selamat Mencoba!!

More Related