Home > IT Answers > Microsoft Windows > How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?
Moron12
5 pts.
 How would you calculate, using the spreadsheets statistical functions, the cheapest option at the fastest speed with the least downtime?
Excel functions, Excel macros, Excel statistical functions, Microsoft Excel, Spreadsheets
i have 5 tables each including speed, price, download limit, average downtime and the average uptime. i was asked by my teacher to calculate all these so i get one number, to find out which is the best value for money for someone to go for. i just need to know what do i calcute to what to get my answers and which letters or numbers i type into excel to get the answer becasue i need to work it out from there.

Software/Hardware used:
ASKED: October 28, 2008  10:11 PM
UPDATED: October 29, 2008  1:45 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The text of the question would be helpful. 

ShawnHendricks
 1,590 pts.
 

Sounds like another homework question. Are the table seperate worksheets or all on the same? That just means referening the cells. Not a big deal. As for the formula? Start with who offers the largets download limit and then level the field to do your calculations. YOu want to be comparing apples to apples, not apples to oranges. 

ToddN2000
 3,910 pts.