Beginning Excel What-If Data Analysis Tools
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, ho...
Đã lưu trong:
| Tác giả chính: | |
|---|---|
| Định dạng: | Sách |
| Ngôn ngữ: | English |
| Được phát hành: |
Apress
2012
|
| Những chủ đề: | |
| Truy cập trực tuyến: | https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/30713 |
| Các nhãn: |
Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
|
| Thư viện lưu trữ: | Thư viện Trường Đại học Đà Lạt |
|---|
| id |
oai:scholar.dlu.edu.vn:DLU123456789-30713 |
|---|---|
| record_format |
dspace |
| spelling |
oai:scholar.dlu.edu.vn:DLU123456789-307132014-01-20T06:46:16Z Beginning Excel What-If Data Analysis Tools Cornell, Paul Technologies 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. I would need to work between 25 and 26 weeks to earn $30,000 if I earn $25.00 per hour working 45 hours per week (assuming I am paid one-and-one-half times my hourly rate for all hours worked over 40 per week). At that pace, I would earn $59,375 if I worked 50 weeks that year and took the remaining two weeks off without pay. These are a few simple examples of the types of problems that the Microsoft Office Excel what-if data analysis tools are designed to solve quickly. This book teaches you how to use these tools. 2012-05-31T01:50:00Z 2012-05-31T01:50:00Z 2006 Book 1-59059-591-2 https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/30713 en application/pdf Apress |
| institution |
Thư viện Trường Đại học Đà Lạt |
| collection |
Thư viện số |
| language |
English |
| topic |
Technologies |
| spellingShingle |
Technologies Cornell, Paul Beginning Excel What-If Data Analysis Tools |
| description |
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.
I would need to work between 25 and 26 weeks to earn $30,000 if I earn $25.00 per hour
working 45 hours per week (assuming I am paid one-and-one-half times my hourly rate for
all hours worked over 40 per week). At that pace, I would earn $59,375 if I worked 50 weeks
that year and took the remaining two weeks off without pay.
These are a few simple examples of the types of problems that the Microsoft Office Excel
what-if data analysis tools are designed to solve quickly. This book teaches you how to use
these tools. |
| format |
Book |
| author |
Cornell, Paul |
| author_facet |
Cornell, Paul |
| author_sort |
Cornell, Paul |
| title |
Beginning Excel What-If Data Analysis Tools |
| title_short |
Beginning Excel What-If Data Analysis Tools |
| title_full |
Beginning Excel What-If Data Analysis Tools |
| title_fullStr |
Beginning Excel What-If Data Analysis Tools |
| title_full_unstemmed |
Beginning Excel What-If Data Analysis Tools |
| title_sort |
beginning excel what-if data analysis tools |
| publisher |
Apress |
| publishDate |
2012 |
| url |
https://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/30713 |
| _version_ |
1819766191222161408 |