Question

Explain the application of spreadsheet in analysis of variance, interpolation and data processing.(computer science)

Answer 1

1.Analysis of variance:
This method is also called as anova,is a collection of some statical model is nothing but a set of assumptions which can be holds for generating some sample data and the data from large group of population.this is called the data generation process.

Example:

A salesman wants to increase the productivity of his products by increasing the speed at which his employees can be using a spreadsheet classes. As he does not haveing an efficent skills,he recruit an third party employee which provides training in this spreadsheet training.he provide 3 courses 1)a beginner2)intermediate3)advanced course.salesman is not sure about the course is needed for the type of work they do at his company, so he sends 10 employees on the simple course, 10 on the normal and 10 on the hard course.all the employees are return from the after completed the training program,he gives them a simple problem to solve by using the spreadsheet,and times how long it takes them to complete the given task. He then checks the all the 3 courses for observing if there are any differences in the average time it took to finish the task.

2.

interpolation:

The process of FINDING a value in a curve or a line between two points.it can mainly used in the statistics.

Example:

i will discuss an example that will clearly explains the depth of interpolation. A man planted a tomato plant and he wants to measured and kept track of its growth every other day. This man is a cunning person, and she would like to know how tall his plant was on the fourth day.

interpolation data table :

Her table of observations looked like this:

day height
1 0
3 4
5 8
7 12
9 16
depend upon the chart diagrams,it not to hard to find out that the plant was was grown 6 mm tall on the 4th day. This is because this tomato plant can be rise in a different pattern ie linear; there was a relationship between the day observed and the growth plant height.Linear pattern means the points developed a straight line. We could also assume by drawing the data on a graph.

3..data processing

a spreadsheet is a sheet that can be made of columns and rows that help organase the data easily,sort data and cal the numeric data. What makes a spreadsheet is designed by software codeis its capible to calculate values using different types mathematical formulas and the data in cells. A example a spreadsheet may be need is developed an overview of your bank's balance. examples of spreed sheets
1.google sheet
2.i work book
3.libreoffice
4.ms excel