Other Math - Wegglab

1. (15 marks) Please see the picture on the next page. The yellow cells are for data; each green cell needs to contain a formula to calculate something. Make an Excel worksheet, putting your name and student number in cell F1. Enter labels as shown into the white cells, and the numbers as shown into the yellow cells, but do not enter the numbers into the green cells. NII the formulas must reference cells; do not embed the data from the yellow cells into the formulas in the green cells. If after doing parts (i), (ii), and (iii), you have put the correct formulas into the green cells, then the numbers will match those shown on the next page. In terms of difficulty. part (i) is casy, part (ii) is medium, and part (iii) is hard. (i) ( 2 marks) Λ Department of Highways wishes to construct a straight road from a point at location ( X 1 ,Y 1 ) (metres cast and north of a standard reference point) in cells A6 and B6 to a point at location (X 2 ,Y 2 ) in cells C6 and D6 . Write the Excel formula to be placed in cell F.6 which calculates the Euclidean distance. (ii) (4 marks) Each student’s record consists of a project, two midterm tests, and a final exam. All these marks are out of 100. The overall mark is based on 10% for the project, 20% for each midterm, and 50% for the final cxam. There is data for three students. Write a formula for cell F 10 to be copied into F10:F12 which computes each mark and rounds it to the nearest integer. Notwithstanding this, a student whose overall mark is <50 but whose mark in the final exam is at least 50 will obtain a final mark of 50 . Write a formula for cell G10 to be copied to G10:G12 which computes each potentially adjusted mark (and leaves it unchangcd otherwisc). (iii) ( 6 marks) For each individual, a country has no income tax payable on the first $10,000 of income, a tax of 20% on the next $40,000 of income, a tax of 35% on the next $50,000 of income, and a tax of 50% on all additional income. For example, the income tax payable by a person who makes $120,000 per year would be: 0%($10,000)+20%($40000)+35%($50,000)+50%($20,000)=$35,500. There are four persons, whose income is in the range D17:D20. Using a nested IF or an IFS function, write the Excel formula for cell F17 to be copied to F17:F20 which computes the income tax for these four individuals. (a) (3 marks) With your name and student number on it, submit the file in normal (numerical) view. (b) ((i)2+(ii)4+( iii )6=12 marks) Either submit at least columns. F and G in formula view (with these columns wide cnough to see all formulas), or in Word or pdf write out the formulas used for cells F6, F10, G10, and F17.

EXPERT ANSWER i. The general formula for Euclidean distance between the given points is The excel formula for this in the cell F6 is =SQRT((C6-A6)^2+(D6-B6)^2) _________________ ii. Below is the formula for F10 to F12 and G10 to G12. In Excel, the formula can be entered in F10 & G10 and then copy-pasted into the remaining …

1. (15 marks) Please see the picture on the next page. The yellow cells are for data; each green cell needs to contain a formula to calculate something. Make an Excel worksheet, putting your name and student number in cell F1. Enter labels as shown into the white cells, and the numbers as shown into the yellow cells, but do not enter the numbers into the green cells. NII the formulas must reference cells; do not embed the data from the yellow cells into the formulas in the green cells. If after doing parts (i), (ii), and (iii), you have put the correct formulas into the green cells, then the numbers will match those shown on the next page. In terms of difficulty. part (i) is casy, part (ii) is medium, and part (iii) is hard. (i) ( 2 marks) Λ Department of Highways wishes to construct a straight road from a point at location ( X 1 ,Y 1 ) (metres cast and north of a standard reference point) in cells A6 and B6 to a point at location (X 2 ,Y 2 ) in cells C6 and D6 . Write the Excel formula to be placed in cell F.6 which calculates the Euclidean distance. (ii) (4 marks) Each student’s record consists of a project, two midterm tests, and a final exam. All these marks are out of 100. The overall mark is based on 10% for the project, 20% for each midterm, and 50% for the final cxam. There is data for three students. Write a formula for cell F 10 to be copied into F10:F12 which computes each mark and rounds it to the nearest integer. Notwithstanding this, a student whose overall mark is <50 but whose mark in the final exam is at least 50 will obtain a final mark of 50 . Write a formula for cell G10 to be copied to G10:G12 which computes each potentially adjusted mark (and leaves it unchangcd otherwisc). (iii) ( 6 marks) For each individual, a country has no income tax payable on the first $10,000 of income, a tax of 20% on the next $40,000 of income, a tax of 35% on the next $50,000 of income, and a tax of 50% on all additional income. For example, the income tax payable by a person who makes $120,000 per year would be: 0%($10,000)+20%($40000)+35%($50,000)+50%($20,000)=$35,500. There are four persons, whose income is in the range D17:D20. Using a nested IF or an IFS function, write the Excel formula for cell F17 to be copied to F17:F20 which computes the income tax for these four individuals. (a) (3 marks) With your name and student number on it, submit the file in normal (numerical) view. (b) ((i)2+(ii)4+( iii )6=12 marks) Either submit at least columns. F and G in formula view (with these columns wide cnough to see all formulas), or in Word or pdf write out the formulas used for cells F6, F10, G10, and F17. Read More »

Which of the following are subspaces of F(-infinity, infinity)?

How many nonnegative integer solutions are there to the pair of equations

Let be a rational preference relation on X. Then the following hold: (a) The strict relation > is irreflexive and transitive. (b) The indifference relation is reflexive, symmetric, and transitive. (C) If x > y and yz, then x > z.

A1 a) How many bits is needed to distinctly address 226 KB in a byte addressable Memory? b) Compute the 111010 2 +110010 2 in signed magnitude form. c) Simplify f(ac)=a⋅ b ˉ +a⋅( b+c )+(a⋅b⋅(c+ b⋅d )+ a⋅b )⋅c⋅d d) Compute ADBE 16 −5AF4 16 using 2’s complement arithmetic

Calculate 4(x, t)|2 from (15.50) and show that the wave packet moves uniformly and at the same time spreads so that h22 (Ax)} = (4x) | 1 + (15.51) 4m²(Ax) -1/2 4(x, t) = [2 (Axhâ] – 1/4 iħt 1 + 2m(4x)? exp x2 ħt + ikox – iko 4(4x) 2m iħt 1+ 2m(4x) (15.50)

You have to color a planar map using only four colors, in such a way that no two adjacent regions have the same color.

Quick Links

Get In Touch

wegglab[at]gmail.com