The Webster National Bank (WNB), a small Midwestern bank is reviewing its service charges and interest­ paying policies on checking accounts. The bank presently has a total of 5,000 checking accounts. Tue bank has found that the average daily balance on all of its personal checking accounts is $550 with a standard deviation of $150. In addition, the average daily balances have been found to be normally distributed. Listed below you will find current balance information on just 20 randomly sampled accounts maintained at WNB.

1) Determine the mean average account balance based upon the sample data.

2) If you were to draw another random sample of 20 observations from the same population, what is the likelihood (probability) that you would find a larger sample mean than the value you calculated in question 1?

3) WNB has conducted some analysis that reveals that approximately 5 percent of its accounts have an average daily balance below $304. Based upon this information, in a randomly drawn sample of 2,000 accounts, what percentage of accounts could be expected to have au average daily balance below $304?

4) Based upon the population data, what percentage of customers carry average daily balances above

$800?

5) Based upon the population data, what is the daily balance level that would you would expect only 25

percent of the customers to exceed?

6) Based upon the population data, what percentage of customers carry average daily balances below

$200?

7) Based upon the population data, what is the daily balance level that would you would expect 90 percent of the customers to exceed?

8) Based upon the population data, what percentage of customers carry average daily balances between

$200 and $700?

9) WNB has conducted some analysis in consideration of invoking minimum balance requirements because some of its clients maintain unprofitable account balances. If WNB is considering a minimum account balance of $127, how many customers would be expected to have a balance below this value?

10) If WNB chose to model the distribution of average daily balances with the discrete distribution shown below, what is the probability of a customer carrying an average daily balance below $751?

daily balance percent of customers               daily balance percent of customers

Days 1 to 120: Number of New Cases

0 1 0 0 2 0 3 0 0 0 0 14 2 1 0 27 80 51 18 26 216 81 37 117 167 108 151 178 111 414 337 195 706 214 300 68 118 160 190 209 154 193 170 154 166 68 119 152 146 101 98 159 175 195 195 157 130 129 161 116 133 217 209 75 298 240 205 196 233 76 339 170 224 236 188 243 244 151 74 286 261 228 239 211 56 388 363 241 335 337 483 163 332 320 314 312 324 380 210 504 425 450 395 1187 1135 179 1994 1374 1365 1231 1238 908 113 1453 693 1437 1249 1208 597 684

Number of ICU hospitalizations in Houston trauma area (cumulative numbers) (84 data points)

214 134 234 260 237 261 179 235 230 230 219 204 200 202 208 198 197 187 195 207 192 145 193 192 205 200 199 187 187 169 197 178 185 174 172 170 179 191 193 225 207 172 190 195 182 187 199 199 196 205 214 230 221 225 236 224 229 240 240 264 233 231 237 226 264 247 297 319 380 362 374 391 393 430 473 499 540 516 570 596 624 654 667 677

For comparisons with the new cases data set align the two data arrays starting from the end. Data for ICU were not maintained for the same time length as new cases. If we use the previous data sets we have two samples (I would not call them random. They are census data). Define the random variables related to these data sets. What kind of RVs those two are? Using the data above examine if there is an association between these two RVs? If there is one. this would be a linear correlation. Would you call this correlation negative or positive and why? What is the interpretation of your findings in simple words?

A student conducted an experiment to determine what factors are important in the rate of a reaction between potassium carbonate and hydrochloric acid. The student diluted 2.000 mL of 4.000 M K2CO3 to 75.00 mL, then combined that solution with 75.00 mL of 2.000 M HCl.

The student tabulated the amount of CO2 gas collected over time and recorded the results in the columns to the left.

1. Use a rearrangement of PV = nRT to solve for the number of moles of CO2 produced. You may assume atmospheric pressure and room temperature. Enter (and fill down) your formula in column C.

This is suppose to be an excel file bt i do not know how to manipulate the formula where I can put it into excel and what information to extract from the problem to use in order to help solve the problem.

HELP PLEASE !!

Are steers and heifers equally distributed between angus and herefords

Please type out answer, thank you.

Question 1

On October 1, 2018, the Marshall Company sold a large piece of machinery to the Hammond Construction Company for $80,000. The cost of the machine was $40,000. Hammond made a down payment of $10,000 and agreed to pay the remaining balance in seven equal monthly installments of $10,000, plus interest at 12% on the unpaid balance, beginning November 1.

Required:

1. Identify three alternative methods for recognizing revenue and costs for the situation described and compute the amount of gross profit that would be recognized in 2018 using each method.
2. Discuss the circumstances under which each of the three methods would be used.

Question 2

Harvey Alexander, an all-league professional football player, has just declared free agency. Two teams, the San Francisco 49ers and the Dallas Cowboys, have made Harvey the following offers to obtain his services:

With both contracts, the annual salary will be paid in one lump sum at the end of the football season.

Required:

You have been hired as a consultant to Harvey’s agent, Phil Marks, to evaluate the two contracts. Write a short letter to Phil with your recommendation including the method you used to reach your conclusion. Assume that Harvey has no preference between the two teams and that the decision will be based entirely on monetary considerations. Also assume that Harvey can invest his money and earn an 8% annual return.

Q.#1 Using Excel Format

The data below show a summary of three major international companies’ financial statements.

Required:

1. Complete the following table:

2. Perform a comparison analysis between the three companies based on following ratios:
   1. Debt ratio
   2. Total Asset Turnover
   3. Net Margin

“Explain your full conclusion for part b”

1. Language development generally takes place in stages. Review page 179, “Visualizing Development – Early Communication and Language Development” of your course text, which discusses the evolution of oral language in young children, and then explain the differences between cooing, babbling, receptive language, and expressive language. Based on the 4 theories of language development theories described on pages 180-185 of your course text, summarize the role of important adults in a young child's language development.
2. As stated in your course text, both a child's temperament and his or her "goodness of fit" can influence early development. Review the Temperament section on pages 192-195 in the text. In your own words, define goodness of fit. Then reflect on your own childhood. Use the information in this section to help you describe your temperament as a young child and whether you experienced goodness of fit with any one person or situation in your early life. As part of your answer, either explain why you believe you experienced goodness of fit, or explain what would have promoted greater goodness of fit with a key person or situation.
3. The course states that, “Each day of looking and learning seems insignificant, yet responses accumulate to develop a toddler who thinks, understands, pretends, and explains.” (Berger, 2018, p.163) Based on the Learning Resources for this week, provide an example of developmental growth that typically occurs between birth and age 2 in each of the domains—physical, cognitive, and social and emotional. Then, briefly explain how experiences accumulate and contribute to each of these developmental changes.

Required: Design a Balanced Scorecard for Triple S-C. Be sure to articulate the linkages among the metrics in the different categories.

Here is the case it pertains to:

Traditionally, steel purchasers fall into one of two groups. Very large customers such as automobile and appliance manufacturers fall into the first category. These customers purchase steel from mills and have it delivered to processors for cutting to specification. They might also buy direct from one or more of the approximately 3,500 steel processors or from wholesalers (normally called service centers). In all three instances, the cut steel is delivered to the customer, often on a just-in-time basis. The second group comprises smaller-volume firms such as metal stampers and fabricators. Firms that make equipment, agricultural tools, and heating and air conditioning units also fall into the second group. These small to midsized companies, which purchase steel as both contract customers and spot buyers, but in relatively small quantities, also tend to have extensive needs for special alloy steels and odd sizes. For the past decade, the variety of the steel demanded has steadily trended up, while the average lot size has trended down. These trends, which partly reflect increased customization and the growth of the just-in-time philosophy, are expected to continue, if not accelerate.

Triple S-C’s founder, Remus Illies, worked at a major steel manufacturer (and was considered a rising star until he quit). Remus realized that the bulk of the distribution industry revolved around coordinating action. Managing information flow is key. Remus therefore set up Triple S-C, which does not own any warehouses or processing facilities. Instead, Triple S-C is a coordinator that buys the steel, has it processed, and has it delivered to the customer. In the process, Triple S-C might deal with as many as six separate entities. Triple S-C maintains an extensive list of firms in the steel supply chain. It has also negotiated prices and terms with many long-standing partners.

Because of its virtual nature and ability to put a deal together on the spot, Triple S-C has convinced its customers about the ease of ordering, processing, and delivery. While Triple S-C accepts orders by phone or fax, it encourages customers to order via electronic data interchange (EDI) or through the Web. Slowly but surely, Triple S-C has convinced its customers about the ease of ordering via the Web and the security of the transaction. Once logged in, customers can configure products on-line and immediately receive multiple quotes with different volume and service parameters. Order status is continually updated and accessible to customers on-line. Upon execution, Triple S-C automatically debits the customer’s bank account per agreed terms.

Triple S-C’s advantage comes from leveraging technology to combine the orders of multiple customers to generate the volumes needed for discounts. The technology also allows Triple S-C to coordinate more effectively with processors to reduce scrap and waste. The firm also seeks to continually expand its list of processors to increase the flexibility it offers end customers. In this fashion, Triple S-C tries to build its ability to combine orders from two different customers into one processing order, which reduces the time and waste involved in loading a multi-tonne coil. The firm also uses its extensive database to identify trends, which enables it to lock in both supplies of alloy and steel and processing time at favorable rates. Remus’s long-term goals are to deal in value-added products such as alloy steels rather than commoditized products such as carbon steel.

Currently, Triple S-C operates out of a single office in Prague and employs just under 40 people. Its primary market area is Central Europe, although Remus is already thinking of westward expansion. Not surprisingly, Triple S-C’s primary target market comprises small to medium-sized firms that lack the volume needed to deal with the steel mills directly and that need specialized processing.

Specifically only need help with f-h.

1. Refer to the Excel “Dixie” data posted on eLearning: (18)
   1. Develop an estimated regression equation with the Revenue serving as the dependent variable and Paper Ads and TV Ads serving as explanatory variables. Write out this estimated equation (use the estimate values!) to explain Revenue.
   2. Show the residual plots where residuals are plotted against each explanatory variable separately. Comment on whether you can proceed with statistical inference based on what you see in the plots. (Hint: Don’t go looking for trouble!)
   3. Provide an interpretation for the three coefficient estimates that you calculated in part “a”. (don’t forget the intercept).
   4. What would your regression model predict the revenue amount to be in a market with 0 TV Ads and 0 Paper Ads? Is this a meaningful prediction? Answer, in a sentence, why or why not.
   5. Provide a 90% confidence interval for your estimate of the Paper Ads Coefficient. Interpret exactly what this 90% confidence interval means.
   6. What statistic and p-value would you use to test the specific null hypothesis that:

Ho: b _{Paper Ads} = b _{TV Ads} = 0

      Do you reject or fail to reject this null hypothesis?

1. g. If I asked you to consider a “backward selection” approach which only included predictors to the model that were significant at a 99% level, then would your answer to part “a” change? If so, what would it change to?
2. h. What percentage of the variation in Revenue can be explained by the model you developed on part “a”? How much more variation does this model explain than a model which uses only TV Ads to help predict Revenue?

Taxes: The Internal Revenue Service reports that the mean federal income tax paid in the year

2010

was

$8040

. Assume that the standard deviation is

$4700

. The IRS plans to draw a sample of

1000

tax returns to study the effect of a new tax law.

(a) What is the probability that the sample mean tax is less than

$8000

? Round the answer to at least four decimal places.