A. The probability that you are dealt pocket aces is 1/221, or 0.00452 to three significant digits. If you studied either Section 4.5 and 4.6 or Section 4.8, verify that probability.

1st Card- 4 cards that are aces out of the 52 cards in the deck.
2nd Card- You already got the 1st ace so now there's only 3 aces out of 51 cards.

0.00452 is the probability of getting dealt "pocket aces".

Therefore the probability is correct.

B. Using the result from part (a), obtain the probability that you are dealt "pocket kings."

Same probability as part (a).
1st Card- 4 cards that are kings out of the 52 cards in the deck.
2nd Card- You already got the 1st king so now there's only 3 kings out of 51 cards.

0.00452 is the probability of getting dealt "pocket kings".

C. Using the result from part (a) and your analysis in part (b), find the probability that you are dealt a "pocket pair," that is, two cards of the same denomination.

0.05882 is the probability of getting a pocket pair.

D. contains at least 1 card of your denomination. (Hint: Complementation Rule.)

Using the Complementation Rule you end up with this:

You already have 2 of the same card which leaves 2 still in the deck.
So the probability of you getting 1 more of the same card in this situation is:

Also the probability of you getting 2 of the same card in this situation is:

Now add them together to get the actual probability because you can get 1 or more of the card in your denomination.

0.03918 is the probability of containing at least 1 card of your denomination.

E. gives you "trips," that is, contains exactly 1 card of your denomination and 2 other unpaired cards.

1st card- 2 cards that's your denomination out of 50.
2nd card- 48 cards that's not your denomination out of 49.
3rd card- 44 cards that wouldn't make a pair out of 48.

...A Brief History of Spreadsheets
by D. J. Power
Editor, DSSResources.COM
Spreadsheets have been used by accountants for hundreds of years. Computerized or electronic spreadsheets are of much more recent origin. Information Systems oral history and some published newspaper and magazine stories celebrate Dan Bricklin as the "father" of the electronic spreadsheet. In 1978, Harvard Business School student, Daniel Bricklin, came up with the idea for an interactive visible calculator (see email from Frankston, 4/15/1999a). Bricklin and Bob Frankston then co-invented or co-created the software program VisiCalc. We can look back and recognize that VisiCalc was the first "killer" application for personal computers.
What is a spreadsheet?
In the realm of accounting jargon a "spread sheet" or spreadsheet was and is a large sheet of paper with columns and rows that organizes data about transactions for a business person to examine. It spreads or shows all of the costs, income, taxes, and other related data on a single sheet of paper for a manager to examine when making a decision.
An electronic spreadsheet organizes information into software defined columns and rows. The data can then be "added up" by a formula to give a total or sum. The spreadsheet program summarizes information from many paper sources in one place and presents the information in a format to...

...Introduction
An electronic, or computerized spreadsheet, can be defined as a software application which displays multiple cells that together make up a grid consisting of rows and columns, each cell containing alphanumeric text, numeric values or formulas which performs the calculation processes (Bessant, 2003; Stroman, Wilson, and Wauson 2004 and Power n. d.). It has been extensively employed ranging from the field of business and financial community to engineering, educational, scientific and medical areas (Ballantine, 1991; Bessant, 2003 and Randles, 2005). This essay firstly, will give a brief outline of development of electronic spreadsheet application and particularly indicate its widespread utilization in accounting sector; emphasis will be largely placed on the critical analysis of advantages and pitfalls of spreadsheet modeling in financial accounting and reporting. Finally, remedies which can reduce the probability of dangers of spreadsheets will be introduced to improve the practicability of spreadsheets.
Ballantine (1991), Walkenbach (2007) and Power (n. d.) acknowledged that VisiValc, which was pioneered by Dan Bircklin and written for the Apple II computer in 1978, should be the first electronic spreadsheet. Admittedly, it essentially laid the foundation for future spreadsheets. Release in 1983, Lotus Development Corporation’s 1-2-3, designed to run on the...

...Robert Roberson
December 1, 2014
Etec 100
Dr. Wilson
Chapter 10 Chapter ten introduces the topic of spread other cells.
A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the
X and Y locations. X locations, the columns, are nord sheets, A spreadsheet is an interactive
computer application program for organization, analysis and storage of data in tabular form. Spreadsheets devel computerized oped as simulations of paper accounting worksheets. The
program operates on data represented as cells of an array, organized in rows and columns. Each
cell of the array is a model–view–controller element that can contain either numeric or text data,
or the results of formulas that automatically calculate and display a value based on the contents
of mally represented by letters, "A", "B", "C", etc., while rows are normally represented by
numbers, 1, 2, 3, etc. A single cell can be referred to by addressing its row and column, "C10"
for instance. Additionally, spreadsheets have the concept of a range, a group of cells, normally
contiguous. For instance, one can refer to the first ten cells in the first column with the range
"A1:A10". This system of cell references was introduced in VisiCalc, and known as "A1
notation".The ability to chain formulas together is what gives a spreadsheet its power. Many ...

...Spreadsheet Exercises Using Excel
Learning Objective:
These exercises are designed to familiarize you with a spreadsheet application software called MS Excel.
After the completion of the lab, you should be able to:
1. work with MS Excel or other spreadsheet programs
2. use functions and formulas in a spreadsheet application software for calculation
3. explain what functions and formulas are, how they work, and the difference between them
Formulas
Well, a formula is a simple calculation that involves either *, /, +, -, or ( ). Of course your formula will ALWAYS start with an = sign. Here are some examples of a few formulas:
* =(5+6)*9
* =(b1+b2)-b12
* =9+10+b6
* =((b10)*10)/(b2+4)
You'll see that beside the mathematical signs, you may have brackets, numbers, or cell addresses.
Functions
A function on the other hand contains "functionality" in that there are parts of the "function" that are programmed into it. For example, let's take the average function. Say we want to take the average of cells B1 to B5.
We could make a formula that looks like one of these example:
Both of these formulas do the same thing. They both add the cells b1 to b5 and then divide the result by 5.
What if you wanted to take the average of 25 cells, 50 cells, 5000 cells. I don't know about you, but I would definitely be a little frustrated. No need to worry though, because the...

...Uncheck Prevent changes to change cell values. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively. Do not show the results.
10
11
Create a third scenario named 200 Attend and using the same changing cells. Uncheck Prevent changes to change cell values. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively. Do not show the results.
10
12
Create a scenario summary report using the total revenue, total expenses, and balance as the results.
14
13
Load the Solver add-in if it is not already loaded. In cell C34 of the Budget worksheet, use Solver to find the highest balance possible by changing the number of attendees and the ticket price per person. Using the Limitations section of the spreadsheet model, add the following constraints:
Number of attendees
Ticket price per person (this will require two constraints based on the minimum and maximum ticket prices)
Keep the Solver dialog box open.
6
14
Add the following constraints to the Solver Parameters:
Valet parking expense (less than or equal to the product of the number of parking stalls and the valet price per vehicle)
Use the number of attendees as the integer constraint
Solve the problem, but keep the original values in the Budget worksheet. Create an Answer report.
9
15
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook....

...Use of Spreadsheets in Business and Technology
Marty Montgomery
August 25, 2013
Many corporations depend on spreadsheets as a fundamental (Institute of Corporate Auditors, 2006) device in their ﬁnancial reporting and operational processes. As a result, the use of spreadsheets is an essential part of the information and decision-making structure for these organizations. In developing and using spreadsheets, organizations need to balance their ease and ﬂexibility against the value of reliable information for management’s application.
As users of spreadsheet applications such as Microsoft Excel® or Lotus 1-2-3® have become more sophisticated, so have spreadsheets. Once used to support simple functions such as logging, tracking and totaling information, spreadsheets with enhanced formulas and built-in advanced features are now used to support such business functions as complex valuation models. The use of macros and multiple spreadsheets which are linked together allows users to build very complicated—and sometimes convoluted—models and other business functions with minimal or no documentation. In addition, these complex spreadsheets are not usually supported by the same control environment as formally-developed, purchased applications. For example, the developers and users of spreadsheets are usually not trained in structured...

...SOLUTION:
(a) Expected time and Variance is calculated in the Excel file attached.
(b) The AOA network is drawn below:
(c ) (d) and (e) done in the Excel Spreadsheet
Q2. Solve problem 25 on page 265 of Mantel.
a. CV
b. SV
c. SPI
d. CPI
SOLUTION:
According to the Question,
Earned Value (EV) = $272,000
Actual Costs (AC) = $270,000
Planned Value (PV) = $261,000
We know that:
Cost Variance (CV):
CV = EV – AC
Cost variance = $272,000 – $270,000 = $2,000
Schedule Variance (SV)
SV = EV – PV
Schedule variance = $272,000 – $261,000 = $11,000
Cost Performance Index (CPI)
CPI = EV / AC
CPI = 272,000/270,000 = 1.01
Schedule Performance Index (SPI)
SPI = EV / PV
SPI = 272,000/261,000 = 1.04
Q4. (Solver) Given the network below:
a. Draw and submit the AOA network
b. What is the critical path?
c. Using Excel Solver, determine the minimum duration. The new price is:
Task Pred Norm t Norm $ Crash t Crash $
A - 3 50 2 150
B A 4 100 2 150
C A 5 200 3 300
D B 6 250 4 350
E C 7 400 4 600
F D, E 3 300 2 450
Suggestion: You may want to go back to Answer 2 of IA-3 and use the excel setup in that file adjusted, of course, for this network.
SOLUTION:
Step 1: Draw the diagram:
D
A B
F
C
E
Step 2: Set up the CPM Spreadsheet
Here, we have 6 activities[ A to F]
In blank spreadsheet,
Type “Activities” in A1
Type Activities letters (i.e. A to F)
In cell A3, type “Nodes”
Row 4,...

...university |
Problem Solving & Spreadsheet Modeling |
CIS331 |
12/16/2012 |
This paper talks about the problem solving process along with examples, as well as one of more commonly used modeling and analytical techniques, i.e. spreadsheet modeling. It also talks about its dependency, its uses, disadvantages and well as explores ways to better this very new, but powerful technique. |
Modeling is the process of creating a simpliﬁed representation of real life problems and representing them in an organized fashion in order to understand a particular problem. These models can take many forms such as mental, visual, mathematical or electronic spreadsheets to name a few. Their uses can be seen in almost every field of our daily lives such as businesses, governments, human resources, science and engineering, and medicine etc. Their primary function is to gain insight into a specific problem and after getting a clear understanding of the topic, one can easily approach it from different directions with possible solutions. This paper discusses this process in detail, starting with gaining insight into a specific problem by using a problem solving model, and then moves on to how it applies to spreadsheet modeling. It also discusses different aspects of electronic spreadsheet engineering, its uses and caveats, as well as its dependency in the business world these days.
Before creating any models,...

2313 Words |
6 Pages

Share this Document

{"hostname":"studymode.com","essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_1.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/stm-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":false,"site_id":1,"autoComplete":false,"isPremiumCountry":false,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":37772101,"categoryName":null,"categoryParentId":null,"currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":3,"pageRange":"1-3","totalPages":3}},"access":"premium","title":"Focus Spreadsheet","additionalIds":[17,19,262,264],"additional":["Literature","Natural Sciences","Sports \u0026 Recreation\/Computer Video Games","Sports \u0026 Recreation\/Hobbies"],"loadedPages":{"html":[],"text":[1,2,3]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/Focus-Spreadsheet-1662361.html","pagesPerLoad":50,"userType":"member_guest","ct":10,"ndocs":"1,500,000","pdocs":"6,000","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.studymode.com\/signup\/","joinUrl":"https:\/\/www.studymode.com\/join","payPlanUrl":"\/checkout\/pay","upgradeUrl":"\/checkout\/upgrade","freeTrialUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fcheckout%2Fpay%2Ffree-trial\u0026bypassPaymentPage=1","showModal":"get-access","showModalUrl":"https:\/\/www.studymode.com\/signup\/?redirectUrl=https%3A%2F%2Fwww.studymode.com%2Fjoin","joinFreeUrl":"\/essays\/?newuser=1","siteId":1,"facebook":{"clientId":"306058689489023","version":"v2.8","language":"en_US"},"analytics":{"googleId":"UA-32718321-1"}}