Excel Homework Assignment 2
Due Date/Time: All Files completed for this assignment must be submitted to Blackboard before class begins on the due date. NOTE: Each file should be saved with your first initial last name followed by the filename instructed by the author. For example, for Problem 1 below, the file should be saved as: pgabriel Iowa Election Results Assignment 2 problems are taken from your text in Tutorials 2 and 3 * Tutorial 2 – Case Problem 3 – Iowa Election Results * Complete the steps for this problem as described by the author * When complete save the files as instructed above

* Print the Iowa Election Results Documentation Worksheet and the data worksheet

* Tutorial 2 – Case Problem 4 – Life Managers Nutrition Table * Complete the steps for this problem as described by the author * Be sure to complete all of the design elements as described in step 4. In your documentation w/s identify where each of these elements can be found in your worksheet. * When complete save the file as instructed above

* Print the documentation worksheet and the Life Managers Nutrition Table Worksheet

* Tutorial 3 – Case Problem 1 – Chemistry 303 – pages 153-154 * Complete the steps for this problem as described by the author. * When complete save the file as instructed above.
* Print the documentation worksheet and the Chemistry worksheet

REMINDER – All three (3) files MUST be submitted at the same time through Blackboard. Assemble your printouts in problem order with the Documentation worksheet on top of each problem and staple. Turn your printouts in at the beginning of class on the due date for full credit.

...You are already familiar with Microsoft Excel software. You have learnt some interesting and useful things that can be done in MS-Excel. Microsoft Excel is an electronic spreadsheet software which allows you to enter, calculate, manipulate, organize and analyze data in the form of tabular form. Let us learn more about data tools provide in Microsoft Excel.
* Data Tools
* Text to Columns
* Remove Duplicates
* Data Validation
* Consolidate
Data Tools
With the powerful data tools included within Microsoft Excel you have the ability to analyze large amounts of data that will influence decisions. Data Validation is a great way to limit what a user can enter into a worksheet cell. It may not stop a cell from being left empty, however. This tip explores why this is and how you can make sure that a cell contains a value. Microsoft Excel’s data consolidate capabilities allows you to summarize your data enhancing your ability to organize and structure your data. Remove Duplicates tool makes your data uniform by removing duplicate records.
Text To Column
If you copy data from another program and paste it into Microsoft Excel, Excel may summarize several columns of data to a single column. You can use the Text To Columns command on the Data menu to put each record in a separate column. The range that you convert may contain many rows, but you can only...

...Frist step , collecting the data from Yahoo. Finance, and calculate the quarterly return by the formula (return of fourth mouth- the return of frist mouth)/ retrun og first mouth
Question a
Average quarterly return= average (all returns of one asset)
Standard deviations= stdeva (all returns of one asset)
Question b and c
File—options—add-ins—solver add in--go, and click all the options, then using the data analysis, choosing correlation (covariance), then selecting all the returns of all assets.
Question d
The average weight= 1/12
Sum of weight =1
Solver portfolio
Return=MMULT(whole covariance matrix, TRANSPOSE(whole correlation matrix))
Variance ==MMULT(average weight,MMULT(whole covariance matrix, TRANSPOSE(average weight)))
Risk =SQRT(Variance)
Mvp
First calculate sigma and return
Sigma =SQRT(MMULT(MMULT(weight,whole covariance matrix),TRANSPOSE(weight)))
Return=MMULT(weight,TRANSPOSE(annual return))
Then using solver set sigma in target cell, choosing min, by changing cells: total weight
The constrains should be sum of weight =1
Lastly, click solve.
Question e
Set a target of sigma ,similarly to one of weight, and though slover,
set the return as target cell, choosing max , by changing cells : all weight, the constraints should be :sigma= target of sigma, sum of weight =1,click solve.
So after getting a new group figure of sigma, return and weight, change target of sigma slowly, and get 10 different sigma result, the last three should...

...Taja Charrier
LSP 120
11/4/13
Activity 12
1. Suppose that you deposit $500 in a bank that offers an annual percentage rate of 6.0% compounded annually.
a. What is your account balance after one year? 530
b. What is your account balance after 10 years? 895.42
2. How long will it take your money to triple at an annual percentage rate of 8% compounded annually? 14.27 years
3. Suppose that you deposit $750 in a bank that offers an annual percentage rate of 4.0% compounded monthly.
a. What is your account balance after one year? 812.25
b. What is your account balance after 8 years? 1234.92
c. What is the annual percentage yield for this account? (Recall that the annual percentage yield is the percentage change in the account for one year, in this case in 12 months.) 8.3%
4. Compare the accumulated balance in three accounts that all start with an initial deposit of $1000. All three accounts have an annual percentage rate of 5.5%, but the first account compounds interest annually, the second account compounds interest quarterly while the third account compounds interest monthly. Make a table that shows the accumulated balance in all three accounts for the first ten years.
a. Paste the first ten rows of each table your Word document.
annual
quarterly
monthly
0
1000
1000
1000
1
1055
1056.144809
1056.408
2
1113.025
1115.441858
1115.998
3
1174.241
1178.068128
1178.949
4
1238.825
1244.210538
1245.451
5
1306.96
1314.066502
1315.704...

...bisection method, the false position method starts with two points a0 and b0 such that f(a0) and f(b0) are of opposite signs, which implies by the intermediate value theorem that the function f has a root in the interval [a0, b0], assuming continuity of the function f. The method proceeds by producing a sequence of shrinking intervals [ak, bk] that all contain a root of f.
At iteration number k, the number
is computed. As explained below, ck is the root of the secant line through (ak, f(ak)) and (bk, f(bk)). If f(ak) and f(ck) have the same sign, then we set ak+1 = ck and bk+1 = bk, otherwise we set ak+1 = ak and bk+1 = ck. This process is repeated until the root is approximated sufficiently well.
The above formula is also used in the secant method, but the secant method always retains the last two computed points, while the false position method retains two points which certainly bracket a root. On the other hand, the only difference between the false position method and the bisection method is that the latter uses ck = (ak + bk)/2
Newton raphson method:
Newton's method (also known as the Newton–Raphson method), named after Isaac Newton and Joseph Raphson, is perhaps the best known method for finding successively better approximations to the zeroes (or roots) of a real-valued function. Newton's method can often converge remarkably quickly; especially if the iteration begins "sufficiently near" the desired root....

...Overview of formulas
Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example, the following formula multiplies 2 by 3 and then adds 5 to the result.
=5+2*3
A formula can also contain any or all of the following: functions, references, operators, and constants.
Parts of a formula
Functions: The PI() function returns the value of pi: 3.142...
References: A2 returns the value in cell A2.
Constants: Numbers or text values entered directly into a formula, such as 2.
Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies.
Using constants in formulas
A constant is a value that is not calculated. For example, the date 10/9/2008.An expression, or a value resulting from an expression, is not a constant. If you use constant values in the formula instead of references to the cells (for example, =30+70+110), the result changes only if you modify the formula yourself.
Using calculation operators in formulas
Operators specify the type of calculation that you want to perform on the elements of a formula. There is a default order in which calculations occur, but you can change this order by using parentheses.
Types of operators
There are four different types of calculation operators: arithmetic, comparison, text concatenation, and reference.
Arithmetic operators
To perform basic mathematical...

...run,
all inputs are variable
3.1 The Production Function
Production function is a tool of analysis used in explaining the input-output relationship.
It describes the technical relationship between inputs and output in physical terms. In its
general form, it holds that production of a given commodity depends on certain specific
inputs. In its specific form, it presents the quantitative relationships between inputs and
outputs. A productionfunction may take the form of a schedule, a graph line or a curve,
an algebraic equation or a mathematical model. The production function represents the
technology of a firm.
An empirical production function is generally so complex to include a wide range of
inputs: land, labour, capital, raw materials, time, and technology. These variables form
the independent variables in a firm’s actual production function. A firm’s long-run
production function is of the form:
Q = f(Ld, L, K, M, T, t) (3.1.1)
where Ld = land and building; L = labour; K = capital; M = materials; T = technology;
and, t = time.
For sake of convenience, economists have reduced the number of variables used in a
production function to only two: capital (K) and labour (L). Therefore, in the analysis of
input-output relations, the production function is expressed as:
Q = f(K, L) (3.1.2)
Equation (3.1.2) represents the algebraic or...

...Life-time examples:
1. In the Deliotte report, it is said 44% of respondents list business intelligence systems as enablers or disruptors that may threaten their business model, which makes it second most concerning technology threat.
2. One example of how business intelligence systems have been maximised is at women’s underwear manufacturer Maidenform. Their CIO Bob Russo said recently after implementing BI, “Providing targeted information at the right place and time is central to improving the decision-making process.
3. Bravissimo is another underwear manufacturer who benefited from using business intelligence systems. They reportly linked their BI tool to the MET office to predict changes in weather.
4. ANZ, proudly tooted their horn in the past when it comes to business intelligence systems. “The analysts are no longer spending all their time building better reports. They are actually doing business analysis that is improving processes and making a real difference.”
5. Just Eat CIO Carlos Morgado also talked about how he implemented a cloud strategy for the online food takeaway business. “We wanted to use off-the-shelf toolsets and not to waste time building what you can buy.”
6. Plantronics and Connotate are another two companies who have used business intelligence systems to their benefit.
Plantronics used dashboards to give a better and graphical view of their opportunity pipeline and help managers by suggesting better allocations of sales resources....

...Week 6
Excel
PF008 A14
Introduction to Spreadsheets
A spreadsheet is an electronic file that contains a
grid of columns and rows used to organize related
data and perform calculations.
Excel is a spreadsheet program used to create and modify
electronic spreadsheets.
An electronic spreadsheet makes data-entry changes easy,
and if the formulas are correctly constructed, the results
recalculate automatically and accurately.
A worksheet is a single spreadsheet that typically contains
descriptive labels, numeric values, formulas, functions, and
graphical representations of data.
A workbook is a collection of one or more related
worksheets contained within a single file. Each worksheet
is identified by a sheet tab. By default, new workbooks
have three worksheets.
The whole file is a workbook
Worksheet
Planning Structure of Worksheets
1. State the purpose of the worksheet
2. Decide what input values are needed
An input area is a range of cells containing values
3. Decide what outputs are needed
An output area is a range of cells containing
results
4. Assign the worksheet inputs and results
Use rows and columns
5. Enter the labels, values, and formulas
6. Format the numerical values
7. Format the descriptive titles and labels
8. Document the worksheet
9. Save the completed workbook
Exploring the Excel Window
• Worksheet rows lie horizontally
• Worksheet columns lie vertically
• A cell is the intersection of...

456 Words |
19 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":34786819,"categoryName":"Products","categoryParentId":"3","currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":1,"pageRange":"1-1","totalPages":1}},"access":"premium","title":"The Functions of Excel","additionalIds":[19,58,5,83],"additional":["Natural Sciences","Business \u0026 Economy\/Industries","Computer Science","Computer Science\/Domains"],"loadedPages":{"html":[],"text":[1]}},"user":null,"canonicalUrl":"http:\/\/www.studymode.com\/essays\/The-Functions-Of-Excel-675772.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"}}