Data Analysis ICT 0417 May/June 2020 IGCSE

Teaching and learning, and many opportunities for its application have yet to be explored. Spreadsheet software is one of the most-used technologies for collecting, computing, and displaying data. Spreadsheets contain a rectangular array of cells in rows and columns that can hold data. Users can create business models, graphs and charts, and reports for financial, statistical, or other data. Most spreadsheet software allows a user to access real-time data from Web sites and to collaborate across teams and workgroups.  * Presentation – Complete video for teachers and learners on Data Analysis  * IGCSE Practice Revision Exercise which covers all the related concepts required for students to unravel any IGCSE Exam Style Data Analysis Questions  * Learner will be able to say authoritatively that, I can use:  The TEXT Function. ...  The VLOOKUP Function. ...  The AVERAGE Function. ...  The CONCATENATE Function  LEN. ...  COUNTA. ...  DAYS/NETWORKDAYS. ...  SUMIFS. ...  AVERAGEIFS. ...  HLOOKUP ….  FIND/SEARCH.  Create a payroll sheet in Excel?  Review Payroll Excel Template and Edit for Your Business. ...  Set Up Payroll Information for Each Employee. ...  Set Up Employer Payroll Tax Information. ...  Enter Hours Worked. ...  Review Automatic Payroll Calculations.  Apply the knowledge of linear Data Analysis in the various fields of study: business, economics, engineering...  Also models life situation such as: transportation, energy, telecommunications, manufacturing…etc with my knowledge of Data Analysis

Probability and Tree Diagrams

Do you know that, probability application areas includes: modelling of text and Web data, network traffic modelling, probabilistic analysis of algorithms and graphs, reliability modelling, simulation algorithms, data mining, and speech recognition More so, Probability means the mathematical chance that something might happen and this is used in numerous day- to-day applications, which includes: weather forecasts, Sports Strategies, Insurance Options, Games and Recreational Activities, Making Business. Tree diagrams are a way of showing combinations of two or more events. Each branch is labelled at the end with its outcome and the probability is written alongside the line. Two events are independent if the probability of the first event happening has no impact on the probability of the second event happening.  * GCSE, IGCSE, AP, PSAT, and IB - Exam Style Questions which covers all the related concepts required for students to unravel any International Exam Style Probability and Tree Diagrams Questions  * Learner will be able to say authoritatively that, I can complete any question on: Listing All Outcomes. Expected Probability. The AND / OR Rule. Tree Diagrams. Probability from Venn Diagrams.

Graphs of Trigonometric Function:

 * GCSE, IGCSE, AP, PSAT, and IB - Exam Style Questions which covers all the related concepts required for students to unravel any International Exam Style trigonometric graphs Questions  * Learner will be able to say authoritatively that:  I can complete any question on how to determine the parameter for a given graph of a trigonometric function  Sketch or complete the graph for any given sine function  Sketch or complete the graph for any given cosine function  Sketch or complete the graph for any given tangent function  Understand the real-life applications of graph of a trigonometric function Why do we need to know what trigonometric graphs look like? • Trigonometric Graphs are used in various applications of mathematics – for example, the oscillating nature can be used to model how a pendulum swings Drawing graphs – trig graphs • As with other graphs, being familiar with the general style of trigonometric graphs will help you sketch them quickly and you can then use them to find values or angles alongside your calculator • All trigonometric graphs follow a pattern – a “starting point” and then “something happens every 90°”.

Simulating Binomial Distribution Density Function and Distribution Graph...

Creating and Simulating a Binomial Distribution Density Function and Distribution Graph Model using Excel Package Teaching and learning and many opportunities for its application have yet to be explored. Spreadsheet software is one of the most-used technologies for collecting, computing, and displaying data. Spreadsheets contain a rectangular array of cells in rows and columns that can hold data. Users can create business models, graphs and charts, and reports for financial, statistical, or other data. Most spreadsheet software allows a user to access real-time data from Web sites and to collaborate across teams and workgroups. Suppose an experiment has the following characteristics:  the experiment consists of n independent trials, each with two mutually exclusive outcomes (success and failure)  for each trial the probability of success is p (and so the probability of failure is 1 – p) Each such trial is called a Bernoulli trial. Let x be the discrete random variable whose value is the number of successes in n trials. Then the probability distribution function for x is called the binomial distribution, B(n, p), and is defined as follows: Where, C(n, x) = and n! = n(n–1)(n–2)⋯3∙2∙1 as described in Combinatorial Functions. This Binomial Distribution Simulation Model is prepared by Aluko Sayo Enoch, as an opportunity to share my love for learning with an entire generation of thinkers and leaders; providing entrepreneurial platform via ICT based on the contemporary Technology Procedure: You can vary the value of p to generate new q, probability density function and equivalent distribution graph. For more info or comment, log on: https://alukosayoenoch.wixsite.com/selfcoding/blog www.unilag.academia.edu/SayoAluko/Papers https://www.tes.com/teaching-resources/shop/alukosayoenoch https://www.youtube.com/feed/my_videos