PLOTTING GRAPH IN EXCEL
11:25 PM
To calculate the average , insert the formula
=AVERAGE(insert the data required),and then enter for the result.
To calculate the variance , insert the formula
=VAR(insert the data required),and then enter for the result.
To calculate the standard deviation , insert the formula
=STDEV(insert the data required),and then enter for the result.
Select the data required and select 'scattered' graph from the
icons
Adjust the axis to suit the size of the graph
Right click at any point in the graph,choose 'trendline' and select linear
to get the straight line axis
tick the boxes for the formula that you need! Done!
0 comments