Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver

By Paul Cornell

Publisher: Apress Published: 1/1/2006 ISBN: 1-59059-591-2 Pages: 193 File type: PDF File size: 2.63 MB About Consider the following two story problems: If I ride a bicycle 5 miles in 20 minutes, how long would it take me at that speed to ride my bicycle 20 miles? At that speed, how far could I ride my bicycle in 45 minutes? If I earn $25.00 per non-overtime hour at a job and I work 45 hours per week, how many weeks would I need to work to earn $30,000 before taxes? How much would I earn before taxes if I worked a 50-week work year and took the remaining two weeks off without pay? Here are the answers to these story problems: It would take me 80 minutes to ride my bicycle 20 miles if I were riding it 5 miles in 20 minutes (that is, 15 miles per hour). At that speed, in 45 minutes I would ride my bicycle 11.25 miles. Download URL: Apress.Beginning.Excel.What.If.Data.Analysis.Tools.Dec.2005.pdf.zip