Microsoft Excel for High School and College Mathematics

19/01/2022

https://www.amazon.com/dp/B09QNYLBP3/ref=sr_1_1?crid=2WD2ZLA1OOP3Y&keywords=aemero+a.+hunegnaw&qid=1642580287&sprefix=aemero+a.+hunegnaw%2Caps%2C369&sr=8-1

Analyzing Data using PivotTables in Microsoft Excel 2019: Practical Guide to Get Quick Insights from Data

08/01/2022

በቅርቡ በሚከተሉት የሒሳብ ርዕሶች (በ11ኛ እና 12ኛ ክፍል ተማሪዎች መጽሐፍት መሰረት) ላይ Microsoft Excelን እንዴት መጠቀም እንደምንችል በምሳሌ ለማሳዬት እንሞክራለን።
1. Statistics and Probability
2. Matrices and Determinants
3. Introduction to Linear Programming
4. Business Mathematics

All for high school students.

05/08/2021

Linear equations and Microsoft Excel
We can use Microsoft Excel to plot linear equations in xy plane, display equations on the line, calculate slope and intercept of a related data. Moreover, we can use Goal Seek feature (command) in Microsoft Excel to make a break-even analysis.

For instance, if y=2x-1, we can plot this equation using Excel. If you are given the values for x (say -4 to 4 (-4,-3,...,4)) and y depends on the values of x, you can use the slope and intercept functions to compute slope and intercept of linear equations. Moreover, if you are given a business data as follows: Revenue(R)=5Q (Q refers to quantity produced and sold).
Total Cost(C)=3Q+1000 (where Q refers quantity produced). We can use the Microsoft Excel to draw the revenue, cost and profit functions. Besides, we can do a break-even (where R=C) analysis and depict the breakeven chart using Microsoft Excel. You can try yourself and we will come up with a brief solution to the above simple mathematical problems. Thank you!