Archives

Changes to the type of chart, data included in the chart, and chart layout and styles can be made from the Layout tab. In association analysis, the antecedent and consequent are sets of items that do not have any items […]

The VLOOKUP function in Excel can be used to generate outcomes from any discrete distribution. In a minimin strategy, the decision which minimizes the minimum payoff is chosen. Answer: TRUE Convenience sampling is an example of a probabilistic sampling method. […]

Below is a spreadsheet of purchase orders for a computer hardware retailer To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12? A) =COUNTIF(D4:D10) B) =SUM(D4:D7) C) =MAX(D4:D7) D) =COUNT(D4:D7) According […]

Using an empirical distribution precludes sampling values outside the range of the actual data. The Risk Solver Platform ________ feature allows you to determine the influence that each uncertain model input has individually on an output variable based on its […]

Which of the following would be considered as an example of a proportional relationships constraint? A) making certain that only a certain amount of units are produced B) guaranteeing that a certain amount of workforce will be available for a […]

The purpose of sampling is to ________. A) enumerate all the values in the population B) measure all items of interest for a particular interest or investigation C) obtain sufficient information to draw a valid inference about a population D) […]

All quadratic optimization models have nonlinear constraints. Explain the similarity between the formulas for computing population mean and expected value of discrete random variable X. Answer: For a discrete random variable X, the expected value, denoted E[X], is the weighted […]

The complexity of a problem increases when the problem belongs to an individual rather than a group. A sample is a subset of a population. Answer: TRUE If a time series has seasonality but no trend, the most appropriate model […]

The worldwide sales of cars from 1981-1990 are shown in the table below. Given: α = 0.2 and β = 0.15 (Hint: Use XLMiner) Using the double exponential smoothing, find the value of the root mean square error for the […]

Following is an extract from the Cost per Order Database of Grogtes LLC. Which of the following will give the value for the third quartile? A) PERCENTILE.INC(array, 0.75) B) QUARTILE.INC(array, 0.75) C) DECILE.INC(array, 0.30) D) QUARTILE.INC(array, 0.25) Stone Age Surfboards […]

Following is an extract from the Cost per Order Database of Grogtes LLC. Which of the following observations is closest to the third quartile? A) 35 N102 nuts for $190.40 B) 59 S103 screws for $556.96 C) 13 N103 nuts […]

The worldwide sales of cars from 1981 -1990 are shown in the table below. Given: α = 0.2, γ = 0.05, and season length = 1. (Hint: Use XLMiner). Which of the following is the forecast value for the 6th […]

Dresden Pharmaceuticals has decided to go ahead and start clinical trials on a potential new drug. The total R&D costs are estimated to reach around $875,000,000 with clinical trials mounting to $145,000,000. The current market size is estimated to be […]

Which of the following is true about the observed errors associated with estimating the value of the dependent variable using the regression line? A) They are the horizontal distances between slopes and y-intercepts. B) The errors are also referred to […]

According to the empirical rules of standard deviation in statistics, approximately 68% of the observations will fall within three standard deviations of the mean. AutoFilter creates filtering criteria based on the type of data being filtered. Answer: TRUE A cyclical […]

The Holt-Winters additive model applies to time series whose amplitude increases or decreases over time. The expected value and variance of the Poisson distribution are equal to λ. Answer: TRUE A value at risk measure considers the magnitude of the […]

The following extract from a manufacturer’s database shows a sample of 10 suppliers, their transportation charges, and the estimated and actual total costs of supplying materials. (Note: Assume a significance level of 0.05 wherever necessary.) Conduct the appropriate type of […]

Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. The machining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are […]

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom […]

What is a stream of historical data known as? A) a time series B) an index C) a complex number D) an orthopole In an event X, the probability of rolling a sum of 8 on two dice is 5/36 […]

The product mix is determined by the: A) accounting staff. B) middle managers. C) finance managers. D) top managers. Below is the spreadsheet for a portfolio allocation model. Answer: D Answer the following question(s) using a model with uncertainty on […]

The mathematical form Y ≤ 450 would be considered as representing a simple bounds constraint. When constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value. Answer: FALSE In a database file, which […]

The standard error may be assumed to be large if the data are clustered close to the regression line. The standard error may be assumed to be large if the data are clustered close to the regression line. Answer: FALSE […]

The R2 value: A) is the variability of the observed Y-values from the predicted values. B) indicates that as the independent variable increases, the intercept term does too. C) gives the proportion of variation in the dependent variable that is […]

Below is a spreadsheet for Trance Electronics. Suppose that the project manager of Trance Electronics has identified the following uncertain variables in the model and the distributions and parameters that describe them, as follows: Market size: normal with mean of […]

Which of the following is true of normal distributions? A) The mean, median, and mode are all equal. B) Its measure of skewness is always greater than 1. C) The range of the random variable X is bounded. D) Mathematical […]

Expected confidence assumes independence between the consequent and the antecedent. Rectilinear distance is the measure of distance as a straight line between two points. Answer: FALSE If P(X|Y) = P(X), it implies that event Y is dependent on event X. […]

Which of the following data sets provides the most realistic estimate of the performance of a model on completely unseen data? A) validation data set B) test data set C) training data set D) linear regression data set The Risk […]

A(n) ________ is an extreme value that is different from the rest of the data. A) critical value B) standard error C) expected value D) outlier The Riviera Transport Company (RTC) produces car accessories at two plants: Dallas and Atlanta. […]

In a MATCH function, the default value for match_type = 0. The Excel function NORM.DIST finds probabilities for the standard normal distribution. Answer: FALSE The expected value and variance of the Poisson distribution are equal to λ. Answer: TRUE A […]

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom […]

Below is the spreadsheet for demand prediction of a company that sells chocolates. Given that D = a-bP, where D, is demand, “a” and “b,” are linear constants, and P, is price, from the below spreadsheet, how will the formula […]

Philip wishes to understand the relative proportion of each data source to the total. Which of the following charts must Philip use? A) Pie chart B) Bar chart C) Scatter chart D) Column chart Below is the spreadsheet for a […]

The ________ algorithm is a classification scheme that attempts to find records in a database that are similar to one we wish to classify. A) linear regression B) logistic regression C) k-Nearest Neighbors D) discriminant analysis Following is an extract […]

Which of the following best defines Monte Carlo simulation? A) It is a tool for building statistical models that characterize relationships among a dependent variable and one or more independent variables. B) It is a collection of techniques that seeks […]

Belowisaspreadsheetofpurchaseordersfor acomputerhardwareretailer. If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to […]

In a two-sample test for means with the population variance being known, the z-test uses a test statistic that is based on the standard normal distribution. In a MATCH function, if match_type = 1, then the function finds the smallest […]

Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. What is the reorder point required to attain a 95% service level? […]

The Atlas Movies Theater is planning to reprice their ticket rates to maximize revenues. They have three classes of tickets: Classic, Silver, and Gold. The table below provides information on the average ticket sales, revenue and price elasticity on demand. […]

Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown […]

Letherin Hides is a company that makes boots specifically targeting college students. Forecasts of sales for the next year are 200 in the summer, 450 in the autumn, and 500 in the winter. Accessories that are used on the boots […]

Jonathan Reese is considering three stocks in which to invest with a fixed budget. The table below provides information on Jonathan’s expected returns for each stock. The table also provides information, collected from market researchers, on the variance-covariance matrix of […]

Which of the following formulas is used to calculate the total studio recording cost? A) =SUM(B6:B12)-B10 B) (B6+B7-B16)B12 C) B6+B7*B12 D) B6+B7*B12-B16 Consider the spreadsheet for a Newsvendor Model. Answer: C What is the value of mean profit? A) $255.90 […]

Solver can generate a Sensitivity report for integer models. Point estimates do not provide any indication of the magnitude of the potential error in the estimate. Answer: TRUE A good regression model has the fewest number of explanatory variables providing […]

Stone Age Surfboards is a small manufacturer of two types of popular high-tide surfboards, the Rockwell and the Limestone models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 15 skilled workers, each of whom […]

Jonathan Reese is considering three stocks in which to invest with a fixed budget. The table below provides information on Jonathan’s expected returns for each stock. The table also provides information, collected from market researchers, on the variance-covariance matrix of […]

The ________ is the observation that occurs most frequently. A) mode B) mean C) outlier D) median Identify the uncontrollable variable from the following inputs of a decision model. A) investment returns B) machine capacities C) staffing levels D) intercity […]

Coppell Services contracts with outsourcing partners to handle various customer service functions. Based on a study of call volumes provided by one of the firm’s partners, the minimum number of staff needed for each hour of the day is as […]

Point estimates do not provide any indication of the magnitude of the potential error in the estimate. Any solution that satisfies all constraints of a problem is called a feasible solution. Answer: TRUE Logistic regression cannot be employed when the […]

Below is a room overbooking model spreadsheet for the Metza, a hotel chain. The hotel has 425 rooms priced at $180 per day each, and is usually fully booked. Reservations can be cancelled any time before 5:00 p.m. with no […]

Measure is the act of obtaining data associated with a metric. Measurements are the numerical values associated with a metric. If the alternative hypothesis includes the symbol <, the rejection region is in the upper tail. Answer: FALSE The mathematical […]

An outcome over which the decision maker has complete control is called an event node. A service level is a constraint that represents the probability that demand can be satisfied. Answer: TRUE Infeasible problems can occur when the demand requirement […]

If bs are weights, Xs are input values, and c is a constant or intercept, provide the equation for discriminant functions, L. A) L = B) L = b1X1 + b2X2 + … + bnXn + c C) L = […]

Bolton Computer’s Laptop Pricing Decision Inputs Price Model Sales -3.85 price + 1150.9 Outputs Total revenue sales price Bolton Computers are planning to release a new line of low-end laptops. Using Excel’s Solver, develop a nonlinear model to calculate the […]

Which of the following is true of association rule mining? A) It develops analytic models to describe the relationship between metrics that drive business performance. B) It identifies attributes that occur frequently together in a given data set. C) It […]

The Riviera Transport Company (RTC) produces car accessories at two plants: Dallas and Atlanta. They ship them to major distribution centers in Houston, San Jose, Jacksonville, and Memphis. The accounting, production, and marketing departments have provided the information in the […]

______are mathematical functions used in predictive analytical models which define phenomena that increase at a specific rate, and is represented by the formula y = axb A) Exponential functions B) Power functions C) Polynomial functions D) Logarithmic functions Below is […]

Which of the following denotes the power of the test? A) α B) 1 – β C) β D) 1 – α Consider the following spreadsheet for an outsourcing decision model. We assume that the production (demand) volume is normally […]

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom […]

To use the VLOOKUP(lookup_value, table_array, col_index_num), the table must be sorted in descending order. For a two-sample test for means with the population variance being known, the Excel procedure used is the Excel z-test. Answer: TRUE The Excel function NORM.DIST […]

Below is the spreadsheet for a project selection model: What is the total return obtained from all five projects? A) $ 860,000 B) $ 550,000 C) $ 700,000 D) $ 395,000 Which of the following Excel functions is applied to […]

While testing for equality of variances, which of the following formulae gives the F-test statistic? A) B) C) D) In sampling, ________ involves assessing the value of an unknown population parameter’“ such as a population mean, population proportion, or population […]

Below is a decision tree for the airline revenue management. What is the expected value of the ticket when a discount is offered on the full fare? [Hint: Choose the approximate value.] A) $ 442.50 B) $ 472.00 C) $ […]

Which of the following would be considered as an example of a proportional relationships constraint? A) making certain that only a certain amount of units are produced B) guaranteeing that a certain amount of workforce will be available for a […]

________ constraints essentially state that input = output and ensure that the flow of material or money is accounted for at locations or between time periods. A) Requirements B) Proportional relationships C) Balance D) Limitations Which of the following measures […]

Coppell Services contracts with outsourcing partners to handle various customer service functions. Based on a study of call volumes provided by one of the firm’s partners, the minimum number of staff needed for each hour of the day is as […]

Shirley Templeton is a real estate agent for Paralol Realty. Shirley is given the responsibility to manage potential customers for 5 of the Realty’s bungalows. These 5 bungalows are situated in close proximity. In order to make traveling easier, Shirley […]

Which of the following is true for a median? A) A median is only meaningful for interval or ordinal data and not for ratio data. B) Medians can be calculated no matter how the data is arranged. C) Medians are […]

Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. What is the reorder point required to attain a 95% service level? […]

The Riviera Transport Company (RTC) produces car accessories at two plants: Dallas and Atlanta. They ship them to major distribution centers in Houston, San Jose, Jacksonville, and Memphis. The accounting, production, and marketing departments have provided the information in the […]

Shirley Templeton is a real estate agent for Paralol Realty. Shirley is given the responsibility to manage potential customers for 5 of the Realty’s bungalows. These 5 bungalows are situated in close proximity. In order to make traveling easier, Shirley […]

Which of the following statements is true when using the Excel Regression tool? A) The range for the independent variable values must be specified in the box for the Input Y Range. B) Checking the option Constant is Zero forces […]

Which of the following is true about determining the proper form of the hypotheses? A) H0 is statistically proved true while testing B) failure to reject H0 proves H1 wrong C) H0 is always assumed to be true in testing […]

Trace the process of copying and pasting a cell, which has a formula in it, such that the formula is not retained in the pasted cell. A) Home – Paste – Paste Special – Paste Values B) Home – Paste […]

One of the properties of the mean is that the sum of the deviations of each observation from the mean is zero. In the average linkage clustering, the distance between two clusters is defined as the average of distances between […]

The economic order quantity is the amount to order that minimizes the total cost of ordering and holding. In a two-sample test for means with the population variance being known, the z-test uses a test statistic that is based on […]

________ sampling applies to populations that are divided into natural subsets and allocates the appropriate proportion of samples to each subset. A) Systematic B) Stratified C) Cluster D) Continuous process In a lower one -tailed hypothesis test, chosen level of […]

Belowisaspreadsheetofpurchaseordersfor acomputerhardwareretailer. To find the total order cost, what Excel formula should be used in A12? A) =COUNT(C4:C10) B) =COUNT(C4:C7) C) =MAX(C4:C10) D) =SUM(E4:E10) Which of the following is true of the t-distribution? A) It has narrower confidence intervals than […]

Which of the following is true about Excel outputs Multiple R? A) It is often referred to as the coefficient of determination. B) A value of 0 indicates positive correlation. C) A negative slope of the regression line denotes a […]

How does the Risk Solver Platform define an uncertain function cell? A) It is a cell that contains a triangular distribution function. B) It is a cell in which a distribution of output values is created from the model. C) […]

For a simple linear regression model, significance of regression is: A) a measure of how well the regression line fits the data. B) a hypothesis test of whether the true regression coefficient 1 is zero. C) a statistic that modifies […]

Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. The machining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are […]

Below is a payoff table that lists three mortgage options: What is the maximum opportunity loss incurred for the 25-year fixed decision? A) $ 8,626 B) $ 13,716 C) $ 14,369 D) $ 10,581 If the given time series has […]

Trace the process of copying and pasting a cell, which has a formula in it, such that the formula is not retained in the pasted cell. A) Home – Paste – Paste Special – Paste Values B) Home – Paste […]

In an event X, the probability of rolling a sum of 8 on two dice is 5/36 while the probability of rolling an 11 is 2/36. In another event Y, the probability of rolling a 2 is 1/36, the probability […]

A global optimum solution is one for which all points close by are no better than the solution. Infeasible problems can occur when the demand requirement is higher than the available capacity. Answer: TRUE The Excel function NORM.DIST finds probabilities […]

Below is the profit model spreadsheet for the Lazarus Shoe Company producing their latest model of shoes for the month of January. Calculate the total profit. A) $600,000 B) $1,436,000 C) $836,000 D) $1,786,000 Answer: A Level of significance is […]

Which of the following is true of the t-distribution? A) It has narrower confidence intervals than the standard normal distribution. B) It is only used to calculate confidence intervals where there is no known population standard deviation. C) It converges […]

In multiple regression, R Square is referred to as the: A) multiple correlation coefficient. B) coefficient of autocorrelation. C) coefficient of multiple determination. D) multiple significance coefficient. Below is a room overbooking model spreadsheet for the Metza, a hotel chain. […]

Shirley Templeton is a real estate agent for Paralol Realty. Shirley is given the responsibility to manage potential customers for 5 of the Realty’s bungalows. These 5 bungalows are situated in close proximity. In order to make traveling easier, Shirley […]

Jonathan Reese is considering three stocks in which to invest with a fixed budget. The table below provides information on Jonathan’s expected returns for each stock. The table also provides information, collected from market researchers, on the variance-covariance matrix of […]

An increase in adjusted R2 indicates that the regression model has improved. According to the interquartile range, extreme outliers are more than 3*IQR away from the left of Q1 or to the right of Q3. Answer: TRUE Logistic regression cannot […]

In a database, information is stored and maintained in ________. A) fields B) measurements C) entities D) attributes Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, […]

What is the formula used to calculate the value of bt in the linear trend equation Ft+k = at + btk while using double exponential smoothing? A) bt = β(bt – bt–1) + (1 –β)bt–1 B) bt = αFt–1 + […]

Which of the following is the equation used for computing the sample correlation coefficient? A) rxy = cov(X,Y)(sxsy) B) rxy = cov(X,Y)/SxSy C) rxy = D) rxy = Which of the following is a continuous random variable? A) the outcomes […]

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom […]

Jonathan Reese is considering three stocks in which to invest with a fixed budget. The table below provides information on Jonathan’s expected returns for each stock. The table also provides information, collected from market researchers, on the variance-covariance matrix of […]

A correlation of 0 indicates that the two variables have no linear relationship with each other. Expected confidence assumes independence between the consequent and the antecedent. Answer: TRUE A chance constraint is one that specifies the fraction of trials in […]

Which of the following is true about chi-square distribution? A) It is a special distribution and is denoted by (C2). B) It is characterized by degrees of freedom. C) It is computed using the Excel function CHISQ.INV.TEST. D) It has […]

Dresden Pharmaceuticals has decided to go ahead and start clinical trials on a potential new drug. The total R&D costs are estimated to reach around $875,000,000 with clinical trials mounting to $145,000,000. The current market size is estimated to be […]

A correlation of 0 indicates that the two variables have no linear relationship with each other. For any sample of fixed size n, the true standard deviation of the sampling distribution of the mean is the standard deviation of the […]

Which of the following is the test statistic for a one-sample test for mean when the population standard deviation is unknown? A) t = B) z = C) z = D) t = Coppell Services contracts with outsourcing partners to […]

________ constraints essentially state that input = output and ensure that the flow of material or money is accounted for at locations or between time periods. A) Requirements B) Proportional relationships C) Balance D) Limitations Categorical variables that have been […]

Which of the following is true of midspread? A) It is an example of a measure of location. B) It is calculated by finding the difference between the highest and lowest values in the data set. C) It is affected […]

Following is an extract from the Employee Payroll Database of HFR Informatics Inc. What is the relative frequency of Grade 3 employees? A) 4 B) 0.55 C) 0.20 D) 5 Answer: Problem statements such as the amount of material used […]

Which of the following generates a scatter chart in Excel with the values predicted by the regression model included? A) Trendline B) Residual Plots C) R Square D) Line Fit Plots The table below provides the sales data for JD […]

The table below provides the sales data for JD Inc. for the year 1998. Given: α = 0.2, β = 0.15, and γ = 0.05 (Hint: Use an additive Holt-Winters model.) Umbrella Sales of JD Inc. Using an appropriate Holt […]

Which of the following is a Type I error? A) the null hypothesis is actually true, and the hypothesis test correctly fails to reject it B) the null hypothesis is actually false, but the test incorrectly fails to reject it […]

Below is a table showing the costs per order of items bought by a computer hardware store. Calculate the mode for the cost per order data. A) $174.17 B) $325 C) $88 D) $206.5 One of the measures of location […]

As the number of degrees of freedom increases, the t-distribution converges to the standard normal distribution. For any sample of fixed size n, the true standard deviation of the sampling distribution of the mean is the standard deviation of the […]

If bs are weights, Xs are input values, and c is a constant or intercept, provide the equation for discriminant functions, L. A) L = B) L = b1X1 + b2X2 + … + bnXn + c C) L = […]

In association analysis, the antecedent and consequent are sets of items that do not have any items in common. The standard error may be assumed to be large if the data are clustered close to the regression line. Answer: FALSE […]

Below is the table showing rate of shoes sold per day and the highest-priced shoe sold that day for a one-week period. The rate of shoes sold per day (X) and the price of the shoes (Y). Use Excel to […]

Below is the spreadsheet for an economic order quantity model. Assume that the distribution of demand is normal with a mean of 20,000 and standard deviation of 2,000. Which of the following cells is defined to be normally distributed using […]

In an event X, the probability of rolling a sum of 8 on two dice is 5/36 while the probability of rolling an 11 is 2/36. In another event Y, the probability of rolling a 2 is 1/36, the probability […]

________ is the ratio of the number of transactions that include all items in the consequent as well as the antecedent to the number of transactions that include all items in the antecedent. A) Lift B) Logit C) Support for […]

A 100(1-α)% confidence interval for the population mean μ based on a sample of size n with a sample mean Ì…and a known population standard deviation σ is given by ________ A) za/2(n-1)( ) B) C) x1 – / (σ […]

Which of the following best defines objective functions? A) They are limitations, requirements, or other restrictions that are imposed on any solution in an optimization model. B) They are quantities that an optimization model seeks to maximize or minimize. C) […]

Mathematically, a binary variable x can be represented as x > 2 and integer. A correlation of 0 indicates that the two variables have no linear relationship with each other. Answer: TRUE As Monte Carlo simulation is essentially statistical sampling, […]

Sujito Electronix makes headphones for $22 and sells them for $32. Sujito has sold at least 50 headphones on average per week in the past, though the actual demand is unknown. Sujito has also often run short of supply in […]

Below is a spreadsheet for Trance Electronics. Suppose that the project manager of Trance Electronics has identified the following uncertain variables in the model and the distributions and parameters that describe them, as follows: Market size: normal with mean of […]

Thefunctionreturnsavalueor referenceof thecellattheintersectionof a particular row and column in a given range. A) VLOOKUP(lookup_value, table_array, col_index_num) B) INDEX(array, row_num, col_num) C) MATCH(lookup_value, lookup_array, match_type) D) HLOOKUP(lookup_value, table_array, row_index_num) Dresden Pharmaceuticals has decided to go ahead and start clinical trials on […]

Remington Textiles has a mill that produces three types of fabrics on a make-to-order basis. The mill operates on a 24/7 basis. The key decision facing the plant manager is about the type of loom needed to process each fabric […]

A 100(1-α)% confidence interval for the population mean μ based on a sample of size n with a sample mean Ì…and a known population standard deviation σ is given by ________ A) za/2(n-1)( ) B) C) x1 – / (σ […]

Which of the following generates a scatter chart in Excel with the values predicted by the regression model included? A) Trendline B) Residual Plots C) R Square D) Line Fit Plots Which of the following is true of an unbiased […]

In stock trading, the higher the coefficient of variation for the stock, the smaller the relative risk is for the return provided. If the Integer Tolerance is set to 0.01, the Solver will stop if it finds an integer solution […]

In order to reject the null hypothesis, the F-test statistic must be greater than the_____. A) p-value B) variance C) df D) F crit The data for the number of hand-held gaming devices sold for the past 5 weeks are […]

In a MATCH function, if match_type = 1, then the function finds the smallest value that is greater than or equal to lookup_value. The standard error may be assumed to be large if the data are clustered close to the […]

In which of the following cases is a proportion of the observations of a sample used in estimating the confidence interval? A) when the degrees of freedom are too large B) when a true sampling distribution cannot be estimated C) […]

In a database file, which is organized in a two-dimensional table, the rows represent records of related data elements. Explain the similarity between the formulas for computing population mean and expected value of discrete random variable X. Answer: For a […]

________ states that for any set of data, the proportion of values that lie within k standard deviations (k > 1) of the mean is at least 1 – 1/k2. A) Prime number theorem B) Bertrand’s postulate C) Oppermann’s conjecture […]

Which of the following is a difference between interval estimates and point estimates? A) Point estimates cannot be used to calculate statistical error, while interval estimate is used to calculate statistical error. B) Point estimates provide only a single value […]

If a simulation has multiple output variables that are related to one another, the distributions of all output variables can be viewed on a single Risk Solver Platform chart called a(n) ________. A) trend chart B) sensitivity chart C) overlay […]

Which of the following allow meaningful comparison of ranges, averages and other statistics? A) interval data B) categorical data C) ratio data D) ordinal data Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the […]

In the equation to calculate the economic value of a customer, V = R F M / D, how is the value for F estimated? A) It is estimated to be the total number of purchases the customer has made. […]

Qualis Investments is a private limited business that manages personal financial portfolios. The company manages six mutual funds and has a client that has acquired $750,000 from an inheritance. Characteristics of the funds are given in the table below. The […]

Which of the following is true of association rule mining? A) It develops analytic models to describe the relationship between metrics that drive business performance. B) It identifies attributes that occur frequently together in a given data set. C) It […]

________ is a collection of techniques that seek to group or segment a collection of objects or observations into subsets, such that those within each subset are more closely related to one another than objects assigned to different subsets. A) […]

What is the slope of the sales function D = a -bP? A) 4 B) 9 C) 12 D) 17 Answer: Qualis Investments is a private limited business that manages personal financial portfolios. The company manages six mutual funds and […]

Given that Q = order quantity, D = annual demand, C = unit cost of the item, C0 = cost per order placed, i = inventory carrying charge per unit, which of the following represents the holding cost per unit? […]

Below is the spreadsheet for a project selection model: What is the return obtained from Project 3? A) $ 200,000 B) $ 125,000 C) $ 275,000 D) $ 225,000 Answer: B If D is demand, P is the unit price, […]

Stone Age Surfboards is a small manufacturer of two types of popular low-tide surfboards, the Graystone and the Lava models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 8 skilled workers, each of whom […]

To find the average of the total cost of orders from Rex Technologies, what Excel formula should be used in A12? A) =AVERAGE(C4:C10) B) =AVERAGE(C4:C7) C) =AVERAGE(E4:E7) D) =AVERAGE(E4:E10) Jonathan Reese is considering three stocks in which to invest with […]