2.99 See Answer

Question: Use the COUNTIF function to construct frequency


Use the COUNTIF function to construct frequency distributions for gender, preferred genre, and influence, develop column charts to express the results visually, and compute the relative frequencies based on the data in the Excel file Video Streaming Services.



> Each can of a certain brand of sweet corn contains an average of 375 corn kernels with a standard deviation of 8 in each can. Yesterday, Winnie went to a local store and purchased four cans of corn. a. Find the probability that the average number of corn

> In determining automobile mileage ratings, it was found that the mpg in the city for a certain model is normally distributed, with a mean of 41 mpg and a standard deviation of 1.8 mpg. Suppose that the car manufacturer samples five cars from its assembly

> Suppose that the mean monthly expenditure of the region identified in Problem 8 is $15,500. What is the probability that the random sample of 380 residents will have a mean monthly expenditure of more than $15,000? Less than $14,500?

> Your college or university wishes to obtain reliable information about student perceptions of administrative communication. Describe how to design a sampling plan for this situation based on your knowledge of the structure and organization of your colleg

> The background for this case was introduced in Chapter 2. This is a continuation of the case in Chapter 6. For this part of the case, propose and test some meaningful hypotheses that will help Ms. Drout understand and explain the results. Include two-sam

> Students in the new MBA class at a state university have the following specialization profile: Finance—83 Marketing—36 Operations and Supply Chain Management—72 Information Systems—59 Find the probability that a student is either a finance or a marketin

> Answer the following by referring to the scenario described in Problem 4. a. Let A be the event “without blue marble.” Find P(A). b. Let B be the event “first marble selected is green.” Find P(B). c. Let C be the event “last marble selected is red.” Find

> Refer to the ball scenario described in Problem 3. a. Let A be the event with the sum of the selected two balls is an odd number. Find P(A) and P(Ac). b. What is the probability that the sum of the two balls will not be more than 5? c. What is the probab

> The latest nationwide political poll in a particular country indicates that the probability for the candidate to be a republican is 0.55, a communist is 0.30, and a supporter of the patriots of that country is 0.15. Assuming that these probabilities are

> Compute the daily change of the closing price for the data in the Excel file S&P 500. Compute descriptive statistics, a frequency distribution, and histogram for the closing prices (using a bin width of 25). What probability distribution would you propos

> Apply the chi-square goodness of fit test to the data in the Airport Service Times Excel file to determine if an exponential distribution models the data. Use bins of width 100. Note that for an exponential distribution, the number of degrees of freedom

> Apply the chi-square goodness of fit test to the data in the Airport Service Times Excel file to determine if a normal distribution models the data. Use bins of width 100. Note that for a normal distribution, the number of degrees of freedom for the CHIS

> The actual delivery time from a pizza delivery company is exponentially distributed with a mean of 28 minutes. a. What is the probability that the delivery time will exceed 31 minutes? b. What proportion of deliveries will be completed within 25 minutes?

> According to WHO, around 1.35 million people die each year due to road accidents. Suppose that on a specific highway, an average of four accidents occur within every hour. Find the probability that the duration between accidents is less than or equal to

> According to historical data, a European musician finds that customers who download music from a popular Web service spend approximately €24 per month, with a standard deviation of €4. Find the probability that a customer will spend at least €22 per mont

> In reviewing your previous reports, several questions came to Elizabeth Burke’s mind. Use point and interval estimates to help answer these questions. 1. What proportion of customers rate the company with “top box” survey responses (which is defined as s

> A fisherman found that the average length of cherry hybrid salmon is about 20 inches with a standard deviation of 2 inches. By assuming the cherry salmon’s length is normally distributed, find the probability that its length is a. more than 25 inches. b

> A box contains marbles of four different colors: red, green, blue, and yellow. Three marbles are randomly chosen from the box. a. List all possible outcomes in the sample space. b. What is the probability of each outcome?

> A popular soft drink is sold in 2-liter (2,000-milliliter) bottles. Because of variation in the filling process, bottles have a mean of 2,000 milliliters and a standard deviation of 18, normally distributed. a. If the process fills the bottle by more tha

> The distribution of SAT scores in math for an incoming class of business students has a mean of 610 and standard deviation of 20. Assume that the scores are normally distributed. a. Find the probability that an individual’s SAT score is less than 600. b.

> In determining bike mileage ratings, it was found that the mpg (X) for a certain model is normally distributed, with a mean of 34 mpg and a standard deviation of 1.9 mpg. Find the following: a. P(X < 33) b. P(31 < X < 38) c. P(X > 36) d. P(X > 33) e. The

> A student is drawing a rectangle, which has a perimeter of 20 cm. He wants the length, x cm, of one side of this rectangle to be uniformly distributed between 1 cm and 7 cm. Find the probability that the length of the longer side of the rectangle is more

> The time required to play a game of Battleship™ is uniformly distributed between 20 and 60 minutes. a. Find the expected value and variance of the time to complete the game. b. What is the probability of finishing within 30 minutes? c. What is the probab

> The number and frequency of hurricanes over a certain ocean, annually from 1945 through 2020, is shown here. For instance, this means that no hurricanes occurred during 6 of these years, only one hurricane occurred in 16 of these years, and so on. a. Fin

> A life insurance consultant sells three life insurance policies on an average per week for which she receives a fee. Use Poisson’s distribution to calculate the probability that in a given week she will sell a. some policies. b. two or more policies but

> A transport company is inspecting 80 trucks it owns. The inspection determines that the probability of trucks failing the inspection is 0.25. Find the probability that not more than 10 trucks failed the inspection. What is the probability that 75 or more

> The background for this case was introduced in Chapter 2. This is a continuation of the case in Chapter 4. For this part of the case, compute confidence intervals for means and proportions and analyze the sampling errors, possibly suggesting larger sampl

> A popular resort hotel has 300 rooms and is usually fully booked. About 7% of the time a reservation is canceled before the 6:00 p.m. deadline with no penalty. What is the probability that at least 285 rooms will be occupied? Use the binomial distributio

> A glass jar contains 10 balls with labels of numbers 1 to 10. Two balls are randomly selected from the glass jar without replacement. a. Determine the number of combinations possible in the sample space. List all possible elements of the sample space. b.

> During one 12-week period, a particular mutual fund outperformed the S&P 500 index 37 out of 60 days. Find the probability that it would perform as well or better again.

> A major application of analytics in marketing is determining customer retention. Suppose that the probability of a long-distance carrier’s customer leaving for another carrier from one month to the next is 0.16. What distribution models the retention of

> From a bag full of colored balls (red, blue, green, and orange), a few are picked out and replaced. This is done 1,000 times and the number of times each colored ball is picked out is, blue balls = 300, red balls =200, green balls = 450, and orange balls

> Padini Concept, a local retail store in Malaysia, recorded the number of shoes purchased by customers (1 pairs, 2 pairs and 3 pairs) based on the number of clothes purchased (1, 2, and 3) for a random sample of 250 customers. The following data was recor

> The number of children per family was determined and summarized in the following table. Find the expected number, variance, and standard deviation of the number of children per family.

> A consumer products company found that 44% of successful products also received favorable results from test market research, whereas 11% had unfavorable results but nevertheless were successful. That is, P(successful product and favorable test market) =

> The students at Sk&Atilde;&para;vde University, Sweden, have elected five candidates to represent them on the college management council. The committee summarized the age and gender of the members as follows: This group of student representatives decide

> Based on the scenario in Problem 3, what is the probability of first selecting ball 1 and then selecting ball 3? Will it be different if the first ball is replaced in the glass jar? Explain the difference between these two scenarios. Data from Problem 3

> PLE has developed a prototype for a new snow blower for the consumer market. This can exploit the company’s expertise in small-gasoline-engine technology and also balance seasonal demand cycles in the North American and European markets to provide additi

> A survey of shopping habits found the percentage of respondents that use technology for shopping as shown in Figure 5.30. For example, 17.39% only use online coupons; 21.74% use online coupons and check prices online before shopping, and so on. a. What i

> A grocery shop is taking stock of its inventory. The shopkeeper found that out of 120 tins with damaged labels, there are 50 tins of beans, 20 tins of sardines, 35 tins of processed meat, and the rest are tins of soup. a. Find the probability that the ti

> Sue and Dave always spend their evenings together, either cycling or playing computer games. On an evening with good weather, the probability that Sue prefers cycling is 0.7 and for Dave it is 0.4. Find the probability that on a particular fine evening,

> In the past week, an ice-cream kiosk sold 15 cups of chocolate flavor, 22 cups of vanilla, and 13 cups of strawberry. a. Estimate the probability of sale of each flavor for the following week. b. Define the definition of probability used to determine the

> Use the Histogram tool to construct frequency distributions and histograms for weekly usage and waiting time in the Excel file Car Sharing Report. Do not group the data into bins.

> A community health status survey obtained the following demographic information from the respondents: Compute the relative frequencies and cumulative relative frequencies of the age groups.

> Airbnb is an online marketplace for arranging or offering lodging, primarily homestays, or tourism experiences. Airbnb provides a platform for hosts to accommodate guests with short term lodging and tourism-related activities. Guests can search for lodgi

> Use the Manufacturing Measurements Data Excel file to compute sample means, assuming that each row in the data file represents a sample from the manufacturing process. Plot the sample means on a line chart, compute the standard deviation of the sample me

> The Excel file Employee Selection contains role of employees in an organization, along with other specifics—gender, salary, years of education, date of birth, and whether they are citizens of the country. Analyze the data using all the tools that have be

> The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the appropriate statistical tools to analyze these data. Summarize the observations that you can make from th

> One of PLE&acirc;&#128;&#153;s manufacturing facilities produces metal engine housings from sheet metal for both mowers and tractors. Production of each product consists of five steps: stamping, drilling, assembly, painting, and packaging to ship to its

> Use the following approaches to analyze the survey data in the Excel file Insurance Survey. ■ Frequency distributions and histograms for the ratio variables (age, years employed, and satisfaction) ■ Descriptive statistical measures for the ratio variable

> Suppose that the average height of all professional basketball players is 6 feet with standard deviation of 5 feet. A player of interest to you is 5.5 feet. Would you consider this player as the outlier? Why

> For the Excel file TV Viewing Survey, is there a significant correlation between (1) the number of TVs in a home and the hours of viewing per week, and (2) age and hours of viewing per week?

> The Excel file House Sales lists a sample of the area (in sq. ft) and prices (in dollars) of various houses. Compute the covariance and correlation between the area and prices.

> Use the Excel file Test Scores and Sales, developed by nine salespersons during the past year, to find the coefficient of correlation between the test scores and sales.

> Find the correlation between weekly food expenditure and monthly household income in the Excel file Food Expenditure.

> For the Peoples Choice Bank database, use PivotTables to find the average transaction amount for each account and branch.

> Use the Excel file Graduation Employment to analyze the average salary and the average percentage of failure rate in interviews among the graduates from the different colleges. What conclusions do you reach?

> Using PivotTables, find the mean and standard deviation of sales by region in the Sales Transactions database.

> The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to design a minimum variance portfolio of index funds to invest some of the firm&acirc;&#128;&#153;s cash reserves. The funds selected for consideration and their variance covariance matrix an

> In the Excel file Debt and Retirement Savings, use a PivotTable to find the mean and standard deviation of income, long-term debt, and retirement savings for both single and married individuals.

> Use a PivotTable to find the mean annual income by level of education for the data in the Excel file Education and Income.

> The Excel file Sample Sales provides sample data on the sales representatives’ record. Create a PivotTable to find the following: a. Cross-tabulation of region versus item. b. Mean units, unit cost, and accumulative sales in each region by item. State th

> Create a PivotTable to find the mean and standard deviation of the amount of travel expenses for each sales representative in the Excel file Travel Expenses.

> In the Excel file Postal Services, find the proportion of the number of items delivered to Portland, New York, and Chicago for six days in four consecutive weeks.

> A teacher recorded the amount of time taken by 21 students to complete a sprint race, to the nearest second, as follows: ■ Two students: between 51 and less than 56 seconds ■ Seven students: between 56 and less than 61 seconds ■ Eight students: between 6

> The amount of time it took 25 respondents to solve a particular task has been recorded in the following table: Develop a table to estimate the sample mean and sample standard deviation of the time using formulas.

> we asked you to use the Histogram tool to construct frequency distributions and histograms for weekly usage and waiting time in the Excel file Car Sharing Report without grouping the data into bins. Use your results and formulas to find the mean and sam

> Construct a frequency distribution for education in the Excel file Voter. Develop a table to estimate the sample mean and sample variance using formulas. Check your results using Excel functions with the original data.

> The Data worksheet in the Excel file Airport Service Times lists a large sample of the time in seconds to process customers at a ticket counter. The second worksheet shows a frequency distribution and histogram of the data. a. Summarize the data using th

> Elizabeth Burke wants to develop a model to more effectively plan production for the next year. Currently, PLE has a planned capacity of producing 9,100 mowers each month, which is approximately the average monthly demand over the previous year. However,

> In each chapter of this book, we use a a fictitious company, Performance Lawn Equipment (PLE), within a case exercise for applying the tools and techniques introduced in the chapter.31 To put the case in perspective, we first provide some background abou

> The Holtz Corporation acquired 80 percent of the 100,000 outstanding voting shares of Devine, Inc., for $7.20 per share on January 1, 2020. The remaining 20 percent of Devine&acirc;&#128;&#153;s shares also traded actively at $7.20 per share before and a

> On January 1, 2020, Paloma Corporation exchanged $1,710,000 cash for 90 percent of the outstanding voting stock of San Marco Company. The consideration transferred by Paloma provided a reasonable basis for assessing the total January 1, 2020, fair value

> Nascent, Inc., acquires 60 percent of Sea-Breeze Corporation for $414,000 cash on January 1, 2018. The remaining 40 percent of the Sea-Breeze shares traded near a total value of $276,000 both before and after the acquisition date. On January 1, 2018, Sea

> The following are several account balances taken from the records of Karson and Reilly as of December 31, 2021. A few asset accounts have been omitted here. All revenues, expenses, and dividend declarations occurred evenly throughout the year. Annual tes

> Miller Company acquired an 80 percent interest in Taylor Company on January 1, 2019. Miller paid $664,000 in cash to the owners of Taylor to acquire these shares. In addition, the remaining 20 per- cent of Taylor shares continued to trade at a total valu

> On January 1, 2019, Telconnect acquires 70 percent of Bandmor for $490,000 cash. The remaining 30 percent of Bandmor&acirc;&#128;&#153;s shares continued to trade at a total value of $210,000. The new subsidiary reported common stock of $300,000 on that

> Posada Company acquired 7,000 of the 10,000 outstanding shares of Sabathia Company on January 1, 2019, for $840,000. The subsidiary’s total fair value was assessed at $1,200,000 although its book value on that date was $1,130,000. The $70,000 fair value

> On January 1, 2021, Morey, Inc., exchanged $178,000 for 25 percent of Amsterdam Corporation. Morey appropriately applied the equity method to this investment. At January 1, the book values of Amsterdam&acirc;&#128;&#153;s assets and liabilities approxima

> On January 1, 2020, Holland Corporation paid $8 per share to a group of Zeeland Corporation shareholders to acquire 60,000 shares of Zeeland&acirc;&#128;&#153;s outstanding voting stock, representing a 60 per- cent ownership interest. The remaining 40,00

> On January 1, 2019, Parflex Corporation exchanged $344,000 cash for 90 percent of Eagle Corporation&acirc;&#128;&#153;s outstanding voting stock. Eagle&acirc;&#128;&#153;s acquisition date balance sheet follows: On January 1, 2019, Parflex prepared the f

> Go to https://about.usc.edu/files/2017/12/USC-Financial-Report-2017.pdf to find the 2017 financial statements for the University of Southern California. Required The financial statements for the University begin on page 11. Use those financial statements

> Plaza, Inc., acquires 80 percent of the outstanding common stock of Stanford Corporation on January 1, 2021, in exchange for $900,000 cash. At the acquisition date, Stanford&acirc;&#128;&#153;s total fair value, including the noncontrolling interest, was

> On January 1, 2020, Palka, Inc., acquired 70 percent of the outstanding shares of Sellinger Company for $1,141,000 in cash. The price paid was proportionate to Sellinger&acirc;&#128;&#153;s total fair value, although at the acquisition date, Sellinger ha

> On January 1, Patterson Corporation acquired 80 percent of the 100,000 outstanding voting shares of Soriano, Inc., in exchange for $31.25 per share cash. The remaining 20 percent of Soriano&acirc;&#128;&#153;s shares continued to trade for $30 both befor

> On January 1, 2021, Johnsonville Enterprises, Inc., acquired 80 percent of Stayer Company’s out- standing common shares in exchange for $3,000,000 cash. The price paid for the 80 percent owner- ship interest was proportionately representative of the fair

> On January 1, 2020, Harrison, Inc., acquired 90 percent of Starr Company in exchange for $1,125,000 fair-value consideration. The total fair value of Starr Company was assessed at $1,200,000. Harrison computed annual excess fair-value amortization of $8,

> On January 1, 2021, Ackerman Company acquires 80% of Seidel Company for $1,712,000 in cash consideration. The remaining 20 percent noncontrolling interest shares had an acquisition-date estimated fair value of $428,000. Seidel’s acquisition-date total bo

> Stockholders’ equity: a. $80,000 b. $90,000 c. $95,000 d. $130,000 (AICPA adapted)

> Noncurrent liabilities: a. $110,000 b. $104,000 c. $90,000 d. $50,000

> Current liabilities: a. $50,000 b. $46,000 c. $40,000 d. $30,000

> Noncurrent assets: a. $130,000 b. $134,000 c. $138,000 d. $140,000

> Vitous Ltd. began operations on January 1, 2018, and uses IFRS to prepare its consolidated financial statements. Although not required to do so, to facilitate comparisons with companies in the United States, Vitous keeps its books in U.S. dollars ($), an

> Current assets: a. $105,000 b. $102,000 c. $100,000 d. $90,000

> What amount is reported for trademarks in the 2021 consolidated balance sheet? a. $508,000 b. $514,000 c. $520,000 d. $540,000

> In 2021, assuming K-Tech has declared no dividends, what are the noncontrolling interest’s share of the subsidiary’s income and the ending balance of the noncontrolling interest in the subsidiary? a. $26,000 and $230,000 b. $28,800 and $252,000 c. $34,40

> What is the 2021 consolidated net income before allocation to the controlling and noncontrolling interests? a. $400,000 b. $486,000 c. $491,600 d. $500,000

> Amie, Inc., has 100,000 shares of $2 par value stock outstanding. Prairie Corporation acquired 30,000 of Amie’s shares on January 1, 2018, for $120,000 when Amie’s net assets had a total fair value of $350,000. On July 1, 2021, Prairie bought an addition

> Goodwill recognized in a business combination must be allocated across a firm’s identified reporting units. For a consolidated entity with multiple reporting units, when is goodwill considered to be impaired? a. When any individual reporting unit’s carry

> How would the answer to problem (5) change if the parent had applied the initial value method rather than the equity method? a. No effect: The method the parent uses is for internal reporting purposes only and has no impact on consolidated totals. b. The

2.99

See Answer