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...

...Krannert Graduate School of Management
Purdue University
MGMT 57000
SPREADSHEET MODELING AND SIMULATION
Spring 2014
Instructor: Yanjun Li, office: KRAN 422, phone: 494-4525, e-mail: li14@purdue.edu
Office Hours: Tuesday 1:00 – 4:00 pm, or by appointment.
Course Packet: The course packet contains cases and readings from various sources.
Textbook: David Hartvigsen, SimQuick: Process Simulation with Excel, 2nd Edition,
Prentice Hall, 2004. (ISBN: 0-13-107880-1)
References: Law, A. M. and W. D. Kelton, Simulation Modeling and Analysis, 3rd Edition, McGraw Hill, 2000.
Luenberger, D. G., Investment Science, Oxford University Press, 1998.
Winston, W. L., Simulation Modeling Using @RISK, Duxbury, 2001.
Computer Software: Palisade Decision Tools, including @RISK, RISKOptimizer, and StatTools, are available in the computer labs in the Krannert building and Rawls Hall. A student version of the software and the installation guide can be downloaded for free at
https://intra.krannert.purdue.edu/admin/kcc/Pages/Resources.aspx.
SimQuick is included in the companion CD of our textbook.
Course Prerequisites: MGMT 67000
COURSE DESCRIPTION
In the past twenty years, Excel spreadsheets have become the standard tool that business people use to model and analyze quantitative problems. The latest versions of these spreadsheet packages contain powerful analytical tools that could...

...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....

...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...

...
Assignment brief
Qualification
BTEC National Diploma for IT Practitioners
Unit number and title
Unit 42: Spreadsheet Modelling
Start date
w/c 3 May 2011
Deadline
w/c 6 June 2011 – (late assignments capped at a pass)
Assessor name
Sheila Cassidy-Allan
Assignment title
Assignment 2 - Enhance, test and evaluate a complex spreadsheet model
The purpose of this assignment is to:
Enhance, test and evaluate the functions of a complex spreadsheet model to meet the advanced needs of a specified user/organisation.
Scenario
Ridgeway is a large college offering a full range of academic courses, together with vocational courses such as plumbing, carpentry and so on. It also offers evening and weekend courses as part of its adult education programmes.
The administration team at Ridgeway want to use spreadsheet software to keep track of student enrolments and course funding for the Year 2011.
Requirements
As per assignment 1 with additional features.
Task 1
The Staff at Ridgeway would benefit from a menu/switchboard function that will enable them to navigate to each sheet from one main menu. Using the following automation methods: (P6)
Create another worksheet called Welcome Sheet. This should be user friendly, with four buttons named Students, Courses, Enrolment and Funding. Record the event of opening each sheet individually using a macro and assign the macro to its appropriate button on your Welcome Sheet.
Add...

...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,...

784 Words |
4 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"}}