Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are $42.76, $81.33, and $58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3, respectively. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the table below.

Means			Stdevs
A	B	C	A	B	C
-30%	-25%	-15%	17%	10%	12%
-3%	4%	8%	10%	8%	6%
20%	25%	22%	15%	10%	10%

a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year.

Round your portfolio value answer to a whole number, and, if necessary, round your portfolio return answer to three decimal digits.

Portfolio value	$
Portfolio return

How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? If necessary, round your answers to three decimal digits.

Pr(Portfolio return < 0%)
Pr(Portfolio return > 25%)

b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the file P16_20.xlsx. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a.

	Great
Portfolio value	$
Portfolio return
Pr(Portfolio return < 0%)
Pr(Portfolio return > 25%)

Repeat this if you learn that the economy is going to be awful.

	Awful
Portfolio value	$
Portfolio return
Pr(Portfolio return < 0%)
Pr(Portfolio return > 25%)

FOR1. Open file Nuclear Power. Select data for Canada. Address the following questions.

a. Provide a plot of the data over time in the space below. (2 pts)

[plot here]

b. Choose an appropriate forecasting model and forecast for the next 3 periods (provide forecast in the table below). Explain model selection approach. (8 pts)

Period	Forecast
2007
2008
2009

c. Using the same data, forecast the next 3 periods in the time series using the 5-period moving average and indicate the values below. (3 pts)

Period	Forecast
2007
2008
2009

d. Using the same data, forecast for the next 3 periods in the time series using the single exponential smoothing technique with a smoothing constant of 0.3 and indicate the values below. (3 pts)

Period	Forecast
2007
2008
2009

e. Compare results from models b, c and d. Which forecast model do you recommend to use for the next 3 periods? Justify your recommendation (6 pts)

DATA:

Nuclear Electric Power Production (Billion KWH)
Year	US	Canada	France
1980	251.12	35.88	63.42
1981	272.67	37.8	99.24
1982	282.77	36.17	102.63
1983	293.68	46.22	135.99
1984	327.63	49.26	180.47
1985	383.69	57.1	211.19
1986	414.04	67.23	239.56
1987	455.27	72.89	249.27
1988	526.97	78.18	260.29
1989	529.35	75.35	288.72
1990	576.86	69.24	298.38
1991	612.57	80.68	314.77
1992	618.78	76.55	321.52
1993	610.29	90.08	349.78
1994	640.44	102.44	341.98
1995	673.4	92.95	358.37
1996	674.73	88.13	377.47
1997	628.64	77.86	375.71
1998	673.7	67.74	368.59
1999	728.25	69.82	374.53
2000	753.89	69.16	394.4
2001	768.83	72.86	400.02
2002	780.06	71.75	414.92
2003	763.73	71.15	419.02
2004	788.53	85.87	425.83
2005	781.99	87.44	428.95
2006	787.22	93.07	427.68

26. Suppose that the money multiplier is 4.3 and that for every $53 billion change in the money supply, interest rates will change by 1.2%. Also, for every 1% change in interest rates, investment will change by $33 billion. And, for every $2.5 billion change in investment, income will change by $7. If the Fed buys $35 billion of bonds, what will be the expected change in the level of investment (rounded off to billions of dollars)?

a. $552 billion. b. $315 billion. c. $112 billion. d. -$150 billion. e. -$228 billion.

27. Suppose that the money multiplier is 4.3 and that for every $53 billion change in the money supply, interest rates will change by 1.2%. Also, for every 1% change in interest rates, investment will change by $33 billion. And, for every $2.5 billion change in investment, income will change by $7. If the Fed sells $35 billion of bonds, what will be the expected change in level of the money supply (rounded off to billions of dollars)?

a. $552 billion. b. $315 billion. c. $112 billion. d. -$150 billion. e. -$228 billion.

28. Suppose that the money multiplier is 4.3 and that for every $53 billion change in the money supply, interest rates will change by 1.2%. Also, for every 1% change in interest rates, investment will change by $33 billion. And, for every $2.5 billion change in investment, income will change by $7. If the Fed sells $35 billion of bonds, what will be the expected change in interest rates (rounded off to one decimal place)?

a. +4.3% b. +2.7% c. +0.3% d. -3.4% e. -6.6%

29. Suppose that the money multiplier is 4.3 and that for every $53 billion change in the money supply, interest rates will change by 1.2%. Also, for every 1% change in interest rates, investment will change by $33 billion. And, for every $2.5 billion change in investment, income will change by $7. If the Fed buys $35 billion of bonds, what will be the expected change in income (rounded off to billions of dollars)?

a. $552 billion. b. $315 billion. c. $112 billion. d. -$150 billion. e. -$228 billion.

**Only answer G-J, I already did A-F**

2. Measuring the height of a California redwood tree is very difficult because these trees grow to heights over 300 feet. People familiar with these threes understand that the height of a California redwood tree is related to other characteristics of the tree, including the diameter of the tree at the breast height of a person (in inches), the thickness of the bark of the tree (in inches), the distance from the closest neighboring tree (in yards), and the number of the other trees neighboring within 10 yards from the tree. Using the data set (Redwood.xlsx), conduct a regression analysis by answering the following questions.

Height 122.0 193.5 166.5 82.0 133.5 156.0 172.5 81.0 148.0 113.0 84.0 164.0 203.3 174.0 159.0 205.0 223.5 195.0 232.5 190.5 100.0

Diameter at breast height 20 36 18 10 21 29 51 11 26 12 13 40 52 30 22 42 45 54 39 36 8

Bark thickness 1.1 2.8 2.0 1.2 2.0 1.4 1.8 1.1 2.5 1.5 1.4 2.3 2.0 2.5 3.0 2.6 4.3 4.0 2.2 3.5 1.4

Distance from the closest 8.5 8.9 6.1 7.6 0.3 3.3 4.8 3.1 3.6 4.1 9.7 3.5 7.2 5.6 7.4 4.4 0.6 6.5 3.1 0.5 5.1

Trees within 10 yard 3 2 5 1 7 4 2 2 1 2 0 5 3 4 2 1 5 2 1 1 0

(g) Determine the coefficient of determination, ? 2 , and interpret its meaning (f) At the level ? = 0.10, is there a significant relationship between the thickness and the pressure? Answer based on the t test in the p-value approach

(h) Determine the adjusted coefficient of determination, adjusted ? 2 , and interpret its meaning

(i) Evaluate the linearity assumption using the residual plot about the independent variable for diameter

(j) Evaluate the normality assumption using the normal probability plot

Cognitive-based therapy (CBT) and family-based therapy (FBT) are two different treatments for anorexia. In an experimental study, forty-six anorexic teenage girls were randomly assigned to two groups. One group, consisting of n1 = 29 individuals, received CBT, and the other group, consisting of n2 = 17 individuals, received FBT. Weight of each individual is measured twice, once at the beginning and once at the end of the study period. The variable of interest is the weight change, i.e. weight after therapy minus weight before therapy. The data collected from the two samples are given below.

cognitive = c(1.7, 0.7, -0.1, -0.7, -3.5, 14.9, 3.5, 17.1,  -7.6, 1.6, 11.7, 6.1,

    1.1, -4.0, 20.9, -9.1, 2.1, -1.4, 1.4, -0.3, -3.7, -0.8, 2.4, 12.6, 1.9, 3.9,

    0.1, 15.4, -0.7)

family = c(11.4, 11.0,  5.5,  9.4, 13.6, -2.9, -0.1,  7.4,  21.5, -5.3, -3.8, 13.4,

    13.1,  9.0,  3.9,  5.7, 10.7)

Note that a positive weight change (weight gain) is generally good for anorexia patients. Let μ1 be the population mean weight change in the CBT group, and μ2 the population mean weight change in the FBT group. The goal is to conduct statistical inference on the difference μ1 − μ2

-

4. Two-sample t-test relies on the assumption that the two samples are either large enough (n1 ≥ 30 and n2 ≥ 30) or coming from normal distributions. In the context of this problem, neither of the two samples is large enough.

(a) Check the normality assumption for both samples using the normal quantile-quantile plot. Re- member that you can do this in R using the qqnorm command.

(b) Suppose one thinks that the normality assumption does not hold for this data set, hence does not trust the results provided in the two-sample t-test. Suggest a different hypothesis testing procedure that does not rely on the normality assumption. (Note: You don’t have to carry out the test.

1. If the variance of ONLY one asset in a two-asset portfolio changes, what other metric changes?
   1. Weight of the asset whose variance changes
   2. Covariance between the two assets in the portfolio
   3. Variance of the other asset
   4. All of the above
   5. None of the above

2. Given the following calculate the geometric mean yield for the entire holding period:

Year	BV	EV
1	100	120
2	120	137
3	137	122
4	122	98
5	98	100

1. 7.2%
2. 7.3%
3. 7.4%
4. 7.5%
5. 0%

3. Using the information below, calculate the expected return:

Economy	Probability	Return
Strong	0.2	20.0%
Weak	0.7	-10.0%
Mild	0.1	5.0%

1. 17.2%
2. -2.2%
3. 17.4%
4. -2.5%
5. 17.6%

4. Which of the following would cause the Security Market Line to pivot upward:

1. A pharmaceutical company receives FDA approval for a new drug
2. Real growth rate of the economy declines
3. The expected rate of inflation increases
4. All of the above
5. None of the above

5. Given the following, calculate the covariance of returns for these two assets:

2006	2007		2008	2009
A)    0.1	0.12		0.07	0.15
B) 0.08	0.04		0.11	0.13

1. 0.01%
2. 0%
3. -0.01%
4. 0.05%
5. -0.05%

6. Calculate the standard deviation of a portfolio comprised of the following two assets that have a correlation coefficient of 0.5:

E(r )	Std Dev	Weight
0.08	0.02	0.7
0.04	0.06	0.3

1. 2.8%
2. 2.9%
3. 3.0%
4. 3.1%
5. -2.2%

7. Suppose the standard deviations of each asset increases by 30% of their original values but the correlation coefficient does not change. What happens to the portfolio standard deviation?
   1. It also increases by 30%
   2. It increases by more than 30%
   3. It increases by less than 30%
   4. It decreases by 30%
   5. I don’t know, but this class is awesome!

8. What is the efficient frontier?
   1. The set of portfolios the represent the best combination of risk and return
   2. The set of portfolios that dominate all other portfolios
   3. The set of portfolios from the MVP to the maximum-risk portfolio
   4. All of the above
   5. None of the above

9. Which is not included in the efficient frontier?
   1. Stocks
   2. Bonds
   3. Real Estate
   4. The risk-free asset
   5. Artwork

Risk analysis is one way to monitor security in an organization. Risk analysis can be a time- consuming process; it involves a number
of steps, some of which require “educated guessing.” Nevertheless, the process alone raises awareness of security issues even if no immediate actions are taken as a result. The steps are:

i. Identify assets (infrastructure, people, hardware, software, reputation, etc.).

For the rest of this list, we’ll concentrate on a single asset.

ii. Determine vulnerability (what event or events might happen to the asset. For example, the building could catch fire, the website could be hacked, etc.).

For the rest of this list, we’ll concentrate on a single asset vulnerable to a single event.

ii. Estimate the probability per year of this event (based on past data, expert estimates, etc.). Take current security measures into account.

iv. Estimate the expected cost if this event occurs (cost to repair or replace, cost of lost business, etc.).

v. Compute risk exposure 5 cost estimate 3 probability estimate.

vi. Identify any additional security measure X that would help protect against this event, determine what it would cost, and do a calculation of the risk exposure with the additional security measure X in place.

vii. Do a cost-benefit analysis:
(Risk exposure without X – Risk exposure with X) − Cost of X

You have a small web-based business that uses a single server to manage your webpage and your customer information. Over the past four years, your website has been hacked and taken down twice. You estimate that the cost of this event is $600 to clean the server and reload the webpage and $12,000 in lost business while the server is down.

1. You could purchase a backup server for a cost of $3,000, which you estimate would reduce the probability per year of losing your website to 0.2. Would this be a cost- effective security measure?

2. What if you reevaluate the probability per year with the backup server to be 0.3. Does this change your answer?

GoodNight Inn case study

Anton Cahoon is trying to decide whether he should make some minor changes in the way he operates his GoodNight Inn motel or if he should join either the Days Inn or Holiday Inn motel chains. Some decision must be made soon because his present operation is losing money. But joining either of the chains will require fairly substantial changes, including new capital investment if he goes with Holiday Inn.

Anton bought the recently completed 60-room motel two years ago after leaving a successful career as a production manager for a large producer of industrial machinery. He was looking for an interesting opportunity that would be less demanding than the production manager job. The GoodNight Inn is located at the edge of a very small town near a rapidly expanding resort area and about one-half mile off an inter- state highway. It is 10 miles from the tourist area, with several nationally franchised full-service resort motels suitable "destination" vacations. There is a Best Western, a Ramada Inn, and a Hilton Inn, as well as many mom-and-pop and limited-service, lower-priced motels-and some quaint bed- and-breakfast facilities-in the tourist area. The interstate highway near the GoodNight Inn carries a great deal of traffic, since the resort area is between several major metropolitan areas. No development has taken place around the turnoff from the interstate highway. The only promotion for the tourist area along the interstate highway is two large signs near the turnoffs. They show the popular name for the area and that the area is only 10 miles to the west. These signs are maintained by the tourist area's Tourist Bureau. In addition, the state transportation department maintains several small signs showing (by symbols) that near this turnoff one can find gas, food, and lodging. Anton does not have any signs advertising GoodNight Inn except the two on his property. He has been relying on people finding his motel as they go toward the resort area.

Initially, Anton was very pleased with his purchase. He had traveled a lot himself and stayed in many different hotels and motels-so he had some definite ideas about what travelers wanted. He felt that a relatively plain but modern room with a comfortable bed, standard bath facilities, and free cable TV would appeal to most customers. Further, Anton thought a swimming pool or any other non revenue producing additions were not necessary. And he felt a restaurant would be a greater management problem than the benefits it would offer. However, after many customers commented about the lack of convenient breakfast facilities, Anton served a free continental breakfast of coffee, juice, and rolls in a room next to the registration desk.

Day-to-day operations went fairly smoothly in the first two years, in part because Anton and his wife handled registration and office duties as well as general management. During the first year of operation, occupancy began to stabilize around 55 percent of capacity. But according to industry figures, this was far below the average of 68% for this classification motels without restaurants.

After two years of operation, Anton was concerned because his occupancy rates continued to be below average. He service resort motels. He stressed a price appeal in his signs and brochures and was quite proud of the fact that he had been able to avoid all the "unnecessary expenses" of the fulling at a very modest price-about 40 percent below the area motels. The customers who stayed at GoodNight Inn said large number of people driving into his parking lot, looking study by the regional tourist bureau. This study revealed the rooms more than 60 days in advance. motels were being planned for the area. After some investigat though they each have about 2,000 units nationwide. economy lodgings. It has been growing rapidly and is willing was far below the average of 68 percent for his classification- motels without restaurants. After two years of operation, Anton was concemed be- 655 decided to look for ways to increase both occupancy rate and profitability and still maintain his independence. Anton wanted to avoid direct competition with the full- service resort motels. As a result, Anton was able to offer lodg- full-service hotels and comparable to the lowest-priced resort they found it quite acceptable. The hotels online reviews at sites like TripAdvisor, while not numerous, were generally pretty positive. But he was troubled by what seemed to be a around, and not coming in to register. Anton was particularly interested in the results of a recent following information about area vacationers: 1. 68 percent of the visitors to the area are young couples and older couples without children. 2. 40 percent of the visitors plan their vacations and reserve 3. 66 percent of the visitors stay more than three days in the area and at the same location. 4. 78 percent of the visitors indicated that recreational facili- ties were important in their choice of accommodations 5. 13 percent of the visitors had family incomes of less than $27,000 per year. 6. 38 percent of the visitors indicated that it was their first visit to the area. After much thought, Anton began to seriously consider affiliating with a national motel chain in hopes of attracting more customers and maybe protecting his motel from the in- creasing competition. There were constant rumors that more ing, he focused on two national chain posibilities: Days Inn and Holiday Inn. Neither had affiliates in the area even Days Inn of America, Inc., is an Atlanta-based chain of to take on new franchisees. A major advantage of Days Inn is that it would not require a major capital investment by An- ton. The firm is targeting people interested in lower-priced motels, in particular, senior citizens, the military, school sports teams, educators, and business travelers. In contrast, Holiday Inn would probably require Anton to upgrade some of his facilities, including adding a swimming pool. The total new capital investment would be between $300,000 and $500,000, depending on how fancy he got. But then Anton would be able to charge higher prices, perhaps $75 per day on the aver- age rather than the $45 per day per room he's charging now. The major advantages of going with either of these na- tional chains would be their central reservation systems and their national names. Both companies offer nationwide, toll- free reservation lines, which produce about 40 percent of all bookings in affiliated motels. Both companies also offer Web sites (www.daysinn.com and www.holiday-inn.com) that help find a specific hotel by destination, rate, amenities, quality rating, and availability. A major difference between the two national chains-is their method of promotion. Days Inn uses little TV advertis- ing and less print advertising than Holiday Inn. Instead, Days Inn emphasizes sales promotions. In one campaign, for exam- ple, Blue Bonnet margarine users could exchange proof-of- purchase seals for a free night at a Days Inn. This tie-in led to the Days Inn system selling an additional 10,000 rooms. tain their facilities and make repairs and improvements as Further, Days Inn operates a September Days Club for travel- ers 50 and over who receive such benefits as discount rates and a quarterly travel magazine. Days Inn also has other membership programs, including its InnCentives loyalty club for frequent business and leisure travelers. Other programs targeted to business travelers in- clude two Corporate Rate programs and its new Days Business Place hotels. Not to be outdone, Holiday Inn has a member- ship program called Priority Club Worldwide. Both firms charge 8 percent of gross room revenues for belonging to their chain-to cover the costs of the reservation service and national promotion. This amount is payable monthly. In addition, franchise members must agree to main- required. Failure to maintain facilities can result in losing the franchise. Periodic inspections are conducted as part of super- vising the whole chain and helping the members operate more effectively. Evalaate Anton Cahoon's present strategy. What should he do? Explain.

MANAGERIAL CHALLENGE Why Charge $35 per Bag on Airline Flights? American Airlines (AA) announced that it would immediately begin charging $35 per bag on all AA flights, not for extra luggage but for the first bag! Crude oil had crushed from $54 to $20 per barrel in the previous 3 months. AA’s new baggage policy applied to all ticketed passengers except first class and business class. On top of incremental airline charges for sandwiches and snacks introduced the previous year, this new announcement stunned the travel public. Previously, only a few deep discount U.S. carriers with very limited route structures such as People Express had charged separately for both food and baggage service. Since American Airlines and many other major carriers had belittled that policy as part of their overall marketing campaign against deep discounters, AA executives faced a dilemma. DEMAND AND SUPPLY: A REVIEW Demand and supply simultaneously determine equilibrium market price (Peq). Peq equates the desired rate of purchase Qd/t with the planned rate of sale Qs/t. Both concepts address intentions—that is, purchase intentions and supply intentions. Demand is therefore a potential concept often distinguished from the transactional event of “units sold.” In that sense, demand is more like the potential sales concept of customer traffic than it is the accounting receivables concept of revenue from completing an actual sale. Analogously, supply is more like scenario planning for operations than it is like actual Jet fuel surcharges had recovered the year-over-year average variable cost increase for jet fuel expenses, but incremental variable costs (the marginal cost) remained uncovered. A quick back-of-the-envelope calculation outlines the problem. If total variable costs for a 500-mile flight on a 180-seat 737-800 rise from $22,000 in 2007 Q2 to $36,000 in 2008 Q2 because of $14,000 of additional fuel costs, then competitively priced carriers would seek to recover $14,000/180 = $78 per seat in jet fuel surcharges. The average variable cost rise of $78 would be added to the price for each fare class. For example, the $188 Super Saver airfare restricted to 14-day advance purchase and Saturday night stay

overs would go up to $266. Class M airfares requiring 7-day advance purchase but no Saturday stay overs would rise from $289 to $367. Full coach economy airfares without purchase restrictions would rise from $419 to $497, and so on. The problem was that by 2008 Q2, the marginal cost for jet fuel had risen to approximately $1 for each pound transported 500 miles. Carrying an additional 170-pound passenger in 2007 had resulted in $45 of additional fuel costs. By May 2008, the marginal fuel cost was $170 – $45 = $125 higher! So, although the $78 fuel surcharge was offsetting the accounting expense increase when one averaged in cheaper earlier fuel purchases, additional current purchases were much more expensive. It was this much higher $170 marginal cost that managers realized they should focus upon in deciding upon incremental seat sales and deeply discounted prices. And similarly, this marginal $1 per pound for 500 miles became the focus of attention in analyzing baggage cost. A first suitcase was traveling free under the prior baggage policy as long as it weighed less than 42 pounds. But that maximum allowed suitcase imposed $42 of marginal cost in May 2008. Therefore, in mid-2008, American Airlines (and now other major carriers) announced a $35 baggage fee for the first bag in order to cover the marginal cost of the representative suitcase on AA, which weighs 25.4 pounds.

Discussion Questions:

a. How should the airline respond when presented with an overweight bag (more than 42 pounds)?

b. Make a list of some of the issues that will need to be resolved if American Airlines decides to routinely charge different prices to customers in the same class of service?

c. What would you do if you were the CEO of AA? Define and justify your Pricing strategy.

Question 1

A worksheet is composed of multiple workbooks.

True

False

Question 2

A1 contains 3 and A2 contains 4. Cell B2 contains = $A$1 ^ $A$1.

What value will cell C2 display if you copy the formula from cell B2 to cell C2?

0

27

12

16

Question 3

Which of the following cannot be a cell reference?

cell1

B3

$C5

$F$3

none of the above is correct

Question 4

What are the 3 most common types of data that are used in a worksheet cell?

Group of answer choices

text, numbers, and formulas

text, numbers, and values

text, sheets, and formulas

names, values, and formulas

none of the above is correct

Question 5

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has =C2 - B5 + A1 in it, what is displayed in cell D1?

3

4

6

7

this formula has a syntax error in it

Question 6

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has =2 * C2 -( B5 + A1) in it, what is displayed in cell D1?

2

4

7

11

none of the above is correct

Question 7

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has = 2 * (C2 - B5) + A1 in it, what is displayed in cell D1?

4

5

10

11

none of the above is correct

Question 8

If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has = 2 * C2 - B5 + A1 in it, what is displayed in cell D1?

5

6

11

none of the above is correct

Question 9

In the formula below, which operator will a worksheet evaluate first?

=A2+B2*(2-5/C3)

=

+

*

-

/

Flag this Question

Question 10

In the formula below, which operation will a worksheet perform first?

=A2+B2*2-5/C3

=

+

*

-

/

Question 11

If cell A1 has 3 in it, cell B2 has 2 in it, what is the value displayed in cell B3 if it contains the following formula?

= 2*A1^B2+1

216

37

19

3

none of the above

Question 12

Which of the choices below is the correct way to express the mathematical value π in a worksheet?

p

pi

=pi

=PI

=PI()

Question 13

If A1 has 3 in it and A2 has 5 in it, what is the value in cell B3 if it contains the following formula?

=SQRT( A1 + 3 * A2 - 2 )

1.73...

2.236...

2.828...

3.46...

4

Question 14

Which formula below is a correct implementation of the square root of the sum of the squares of B2 and C3?

Group of answer choices

=SQRT( B2 + C3 )

=SQRT( B2 ^ 2 + C3 ^ 2)

=SQRT( B2 + C3 ) ^ 2

=SQRT( B2 ^ 2 ) + SQRT( C3 ^ 2 )

none of the above

Question 15

Which is the correct formula in a spreadsheet program to calculate x in the equation 10^x = 27?

=LOG10( 27 )

=SIN( 27 )

=LOG( 10, 27 )

=LN ( 20 )

none of the above

Question 16

Which of the following is NOT an acceptable range in a worksheet?

F2:G4

G, H

A1:A3

B3:B1

Question 17 1 pts

The formula below is in cell C5. If the formula is copied and pasted into D6, how will it appear?

= A1^(2-B2)

Group of answer choices

= B2^(2-C3)

= A1*(2-B2)

= C5^(2-D6)

= A1^(2-B2)

none of the above

Question 18

Which formula below has a syntax error in it?

= A2 + A3 - EXP( A4 )

= A2 + A3 - SQRT( A3 - A4 )

= LOG10(A2 + A3 - LOG10( A4 )

= A2 + 3 * A3 - PI()

= LN( SQRT( A2 + A3 - A4) )

Question 19

A spreadsheet has -2 in cell A3 and 4 in cell B7. Exactly what will be displayed in cell C5 if it contains exactly the following (be careful!):

B7/A3

Group of answer choices

0

-2

2

B7/A3

Question 20

In a worksheet, cell A1 contains 5 and A2 contains miles. What is displayed in cell B4 if it contains the formula

=A1 + A2?

5miles

5 miles

A1 + A2

error message

5