PPT - Extract ASDA Grocery Prices and Stock Available Data PowerPoint Presentation

Extract ASDA Grocery Prices and Stock Available Data

Nov 18, 2025

0 likes | 0 Vues

Extract ASDA Grocery Prices and Stock Available Data to analyze pricing trends, stock availability, and retail performance insights. By developing a custom API solution to Extract ASDA Online Supermarket Inventory Data, we empowered retailers, researchers, and analytics firms to monitor ASDAu2019s supply chain efficiency and restocking patterns.

Extract ASDA Grocery Prices and Stock Available Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

ACC 206 Complete Class All Assignments ,DQs and Problems

ACC 206 Complete Class All Assignments ,DQs and Problems Purchase here http://chosecourses.com/acc-206-complete-class-all-assignments-dqs-and-problems Description ACC 206 Complete Class All Assignments ,DQs and Problems ACC 206 Week 1 Assignment Chapter 1 Problems Why are noncash transactions, such as the exchange of common stock a building, included on a statement of cash flows? How are these noncash transactions disclosed? Chapter 1 Exercise 1: 1. Classification of activities Classify each of the following transactions as arising from an operating (O), investing (I), financing (F), or noncash investing/financing (N) activity. and so on... Chapter 1 Exercise 4: 4. Overview of direct and indirect methods Evaluate the comments that follow as being True or False. If the comment is false, briefly explain why. a. Both the direct and indirect methods will produce the same cash flow from operating activities. b. Depreciation expense is added back to net income when the indirect method is used. c. One of the advantages of using the direct method rather than the indirect method is that larger cash flows from financing activities will be reported. d. The cash paid to suppliers is normally disclosed on the statement of cash flows when the indirect method of statement preparation is employed. e. The dollar change in the Merchandise Inventory account appears on the statement of cash flows only when the direct method of statement preparation is used. Chapter 1 Exercise 6: 6. Equipment transaction and cash flow reporting New equipment purchased during 20x4 totaled $280,000. The 20x4 income statement disclosed equipment depreciation expense of $41,000 and a $9,000 loss on the sale of equipment. a. Determine the cost and accumulated depreciation of the equipment sold during 20X4. b. Determine the selling price of the equipment sold. c. Show how the sale of equipment would appear on a statement of cash flows prepared by using the indirect method. Chapter 1 Problem 3: 3. Cash flow information: Direct and indirect methods The comparative year-end balance sheets of Sign Graphics, Inc., revealed the following activity in the company's current accounts: ACC 206 Week 1 DQ 1 Cash Flow Information What information does the cash flow statement provide that you cannot see in the other financial statements (income statement, balance sheet, owner’s equity)? What elements of the cash flow statement do you think are most important for company management to monitor and why? Is this different for investors? ACC 206 Week 1 DQ 2 Apple’s Cash Flow Go to http://finance.yahoo.com. Enter in “AAPL” and click on the “get quote” button, and it will bring up information on Apple. On the left hand side you’ll see a section on Financials. Within that section, click on the cash flow. Review the cash flow statement for Apple. How would you summarize Apple’s cash flow position and what does this statement tell you about where the money is coming from and where it’s going? What would you suggest Apple’s do to improve its cash position and why? ACC 206 Week 2 Assignment Chapter 2 and 3 Problems Chapter Two and Three Problems Please complete the following 7 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button. Chapter 2 Exercise 1 1. Issuance of stock Prepare journal entries to record the issuance of 100,000 shares of common stock at $20 per share for each of the following independent cases: a. Jackson Corporation has common stock with a par value of $1 per share. b. Royal Corporation has no-par common with a stated value of $5 per share. c. French Corporation has no-par common; no stated value has been assigned Chapter 2 Exercise 3 3. Analysis of stockholders' equity Star Corporation issued both common and preferred stock during 20X6. The stockholders' equity sections of the company's balance sheets at the end of 20X6 and 20X5 follow. Chapter 2 Problem 1 1. Bond computations: Straight-line amortization Southlake Corporation issued $900,000 of 8% bonds on March 1, 20X1. The bonds pay interest on March 1 and September 1 and mature in 10 years. Assume the independent cases that follow. • Case A—The bonds are issued at 100. • Case B—The bonds are issued at 96. • Case C—The bonds are issued at 105. Southlake uses the straight-line method of amortization. Chapter 3 Exercise 1 1. Product costs and period costs The costs that follow were extracted from the accounting records of several different manufacturers: 1. Weekly wages of an equipment maintenance worker 2. Marketing costs of a soft drink bottler 3. Cost of sheet metal in a Honda automobile 4. Cost of president's subscription to Fortune magazine 5. Monthly operating costs of pollution control equipment used in a steel mill 6. Weekly wages of a seamstress employed by a jeans maker 7. Cost of compact discs (CDs) for newly recorded releases of Rush, Billy Joel, and Bryan Adams a. Determine which of these costs are product costs and which are period costs. b. For the product costs only, determine those that are easily traced to the finished product and those that are not. Chapter 3 Exercise 2 2. Definitions of manufacturing concepts Interstate Manufacturing produces brass fasteners and incurred the following costs for the year just ended: Materials and supplies used Chapter 3 Exercise 5 5. Schedule of cost of goods manufactured, income statement The following information was taken from the ledger of Jefferson Industries, Inc.: Chapter 3 Problem 3 3. Manufacturing statements and cost behavior Tampa Foundry began operations during the current year, manufacturing various products for industrial use. One such product is light-gauge aluminum, which the company sells for $36 per roll. Cost information for the year just ended follows. ACC 206 Week 2 DQ 1 Stock Features 1. What is callable preferred stock? Why do corporations issue such stock? Given the different features that are associated with stock (callable, cumulative, preferred, etc.), what type of stock would you want to buy personally and why? ACC 206 Week 2 DQ 2 Role of Management Accounting Role of Management Accounting Review the roles of management accounting within a company. What is the most important role of management accounting? How is that different than financial accounting? ACC 206 Week 2 Exercise Solution ACC 206 Week 2 Journal Institute of Management Accounting Institute of Management Accounting While there are many instances of overlap between financial accounting and management accounting, each group’s primary focus is different. Review the Institute of Management Accounting’s (IMA) website, specifically the “About IMA” and the “Resources and Publications” sections of the website. Are you surprised by the topics that management accountants are focusing on? Why or why not? What interests you more, financial accounting or management accounting? Carefully review the Grading Rubric for the criteria that will be used to evaluate your journal entry. ACC 206 Week 3 Assignment Chapter 4 and 5 Problems Chapter 4 and 5 Problems Please complete the following 7 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button. Chapter 4 Exercise 3 3. Cost flows and overhead application Cleveland Metals uses a job cost system and applies factory overhead to production at a predetermined rate of 180% of direct labor cost. Data pertaining to recent operations follow. Job no. 636 was the only job in process on January 1 of the current year. The Work in Process account contained a $24,600 balance on this date. Jobs no. 637, 638, and 639 were started during January. Total direct material requisitions and direct labor incurred during January amounted to $89,200 and $114,500, respectively. • The only job that remained in process on January 31 was job no. 638, with costs of $15,000 for direct materials and $20,000 for direct labor. a. Compute the total cost of the work in process inventory on January 31. b. Compute the cost of jobs completed during January, and present the proper journal entry to reflect job completion. Chapter 4 Exercise 7 7. Overhead application: Working backward The Towson Manufacturing Corporation applies overhead on the basis of machine hours. The following divisional information is presented for your review: Chapter 4 Problem 2 2. Computations using a job order system General Corporation employs a job order cost system. On May 1 the following balances were extracted from the general ledger; Chapter 5 Exercise 2 The treasurer anticipates the following costs for the event, which will be held at the Regency Hotel: Chapter 5 Exercise 3 3. Break-even and other CVP relationships Cedars Hospital has average revenue of $180 per patient day. Variable costs are $45 per patient day; fixed costs total $4,320,000 per year. Chapter 5 Problem 6 6. Direct and absorption costing The information that follows pertains to Consumer Products for the year ended December 31, 20X6. ACC 206 Week 3 DQ 1 Issues in Costing Issues in Costing Describe three issues/problems that a company could encounter when trying to determine the actual cost of a good or service to be used in the cost of goods sold. For each of your issues, provide an example of a company or industry where these issues could be present. Guided Response: Review your peers’ posts and respond to at least two of your classmates. Describe how job order costing or activity-based costing could resolve the issues your classmates mentioned in their posts. ACC 206 Week 3 DQ 2 CVP and the Airline Industry CVP and the Airline Industry We’ve all experienced (or heard about) the challenges that the airlines have been facing. Read the Zacks Investment Research article, “Airline Industry Stock Outlook – August 2012” Identify three factors that are affecting airline company’s ability to break even. For each of your factors, discuss how these have an impact on the breakeven (contribution margin, fixed costs, variable costs, a combination, etc.), and what happens if these factors increase or decrease. ACC 206 Week 3 Exercise Solution ACC 206 Week 3 Journal Hershey Company Hershey Company Go the Hershey website to learn how to make Hershey chocolate. Review the process and take a look at some of the videos. Pay particular attention to the process steps of milling and pressing, mixing the ingredients, and refining. In at least one paragraph, describe the costing system that you would recommend Hershey use to account for its cost of goods sold and why. Include a few product costs you think would be traceable, which costs should be allocated, and how Hershey should account and apply the manufacturing overhead costs. Carefully review the Grading Rubric for the criteria that will be used to evaluate your journal entry. ACC 206 Week 4 Assignment Chapter 6 and 7 Problems Chapter 6 Exercise 2 2. Schedule of cash collections Sugarland Company sells a single product and anticipates opening a new facility in Charlotte on May 1 of the current year. Expected sales during the first three months of activity are: May, $60,000; June, $80,000; and July, $85,000. Thirty percent of all sales are for cash; the remaining 70% are on account. Credit sales have the following collection pattern: Chapter 6 Exercise 4 4. Production and cash-outlay computations RPR, Inc., anticipates that 120,000 units of product K will be sold during May. Each unit of product K requires four units of raw material A. Actual inventories as of May 1 and budgeted inventories as of May 31 follow. Chapter 6 Exercise 5 5. Abbreviated cash budget; financing emphasis An abbreviated cash budget for Big Chuck Enterprises follows. Chapter 6 Problem 3 3. Comprehensive budgeting The balance sheet of Watson Company as of December 31, 20X1, follows. Chapter 7 Exercise 3 3. Variances for direct materials and direct labor Banner Company manufactures flags of various countries. Each flag has a standard of eight square feet of fabric and three hours of direct labor time. Information about recent production activity follows. Chapter 7 Exercise 5 5. Overhead variances Nova Manufacturing applies factory overhead to products on the basis of direct labor hours. At the beginning of the current year, the company's accountant made the following estimates for the forthcoming period: Estimated variable overhead: $500,000 Estimated fixed overhead: $400,000 • Estimated direct labor hours: 40,000 It is now 12 months later. Actual total overhead incurred in the manufacture of 7,900 units amounted to $895,100. Actual labor hours totaled 39,800. Assuming a direct labor standard of five hours per finished unit, calculate the following: a. Variable overhead efficiency variance b. Fixed overhead volume variance c. Overhead spending variance Chapter 7 Problem 1 1. P26-A1 Basic flexible budgeting (L.O. 2) Centron, Inc., has the following budgeted production costs: Chapter 7 Problem 5 5. P26-B3 Straightforward variance analysis (L.O. 5) Arrow Enterprises uses a standard costing system. The standard cost sheet for product no. 549 follows. ACC 206 Week 4 DQ 1 Issues in Standard Costs and Budgeting Issues in Standard Costs and Budgeting Review the Standard costs: wake up and smell the coffee.article. When evaluating performance, many organizations compare current results with the actual results of previous accounting periods. Is an organization that follows this approach likely to encounter any problems? Explain. ACC 206 Week 4 DQ 2 Flexible budgets Flexible budgets provide different information than static budgets. Discuss some of these differences. Is a flexible budget always better? Are there times when you’d recommend using a static budget over a flexible budget? ACC 206 Week 4 Exercise Solution ACC 206 Week 5 Assignment Chapter 8 Problems Chapter 8 Exercise 1: 1. Basic present value calculations Calculatehttps://store-6f7yjf.mybigcommerce.com/admin/index.php?ToDo=addProduct the present value of the following cash flows, rounding to the nearest dollar: a. A single cash inflow of $12,000 in five years, discounted at a 12% rate of return. b. An annual receipt of $16,000 over the next 12 years, discounted at a 12% rate of return. c. A single receipt of $15,000 at the end of Year 1 followed by a single receipt of $10,000 at the end of Year 3. The company has a 10% rate of return. d. An annual receipt of $8,000 for three years followed by a single receipt of $10,000 at the end of Year 4. The company has a 12% rate of return. Chapter 8 Exercise 4: 4. Cash flow calculations and net present value On January 2, 20X1, Bruce Greene invested $10,000 in the stock market and purchased 500 shares of Heartland Development, Inc. Heartland paid cash dividends of $2.60 per share in 20X1 and 20X2; the dividend was raised to $3.10 per share in 20X3. On December 31, 20X3, Greene sold his holdings and generated proceeds of $13,000. Greene uses the net-present- value method and desires a 16% return on investments. a. Prepare a chronological list of the investment's cash flows. Note: Greene is entitled to the 20X3 dividend. b. Compute the investment's net present value, rounding calculations to the nearest dollar. c. Given the results of part (b), should Greene have acquired the Heartland stock? Briefly explain. Chapter 8 exercise 5: 5. Straightforward net present value and internal rate of return The City of Bedford is studying a 600-acre site on Route 356 for a new landfill. The startup cost has been calculated as follows: Purchase cost: $450 per acre Site preparation: $175,000 The site can be used for 20 years before it reaches capacity. Bedford, which shares a facility in Bath Township with other municipalities, estimates that the new location will save $40,000 in annual operating costs. a. Should the landfill be acquired if Bedford desires an 8% return on its investment? Use the net-present-value method to determine your answer. Chapter 8 Problem 1: 1. Straightforward net-present-value and payback computations STL Entertainment is considering the acquisition of a sight-seeing boat for summer tours along the Mississippi River. The following information is available: Chapter 8 Problem 4: 4. Equipment replacement decision Columbia Enterprises is studying the replacement of some equipment that originally cost $74,000. The equipment is expected to provide six more years of service if $8,700 of major repairs are performed in two years. Annual cash operating costs total $27,200. Columbia can sell the equipment now for $36,000; the estimated residual value in six years is $5,000. New equipment is available that will reduce annual cash operating costs to $21,000. The equipment costs $103,000, has a service life of six years, and has an estimated residual value of $13,000. Company sales will total $430,000 per year with either the existing or the new equipment. Columbia has a minimum desired return of 12% and depreciates all equipment by the straight-line method. Instructions: a. By using the net-present-value method, determine whether Columbia should keep its present equipment or acquire the new equipment. Round all calculations to the nearest dollar, and ignore income taxes. b. Columbia's management feels that the time value of money should be considered in all long-term decisions. Briefly discuss the rationale that underlies management's belief. ACC 206 Week 5 Final Paper Focus of the Final Paper You’ve just been hired onto ABC Company as the corporate controller. ABC Company is a manufacturing firm that specializes in making cedar roofing and siding shingles. The company currently has annual sales of around $1.2 million, a 25% increase from the previous year. The company has an aggressive growth target of reaching $3 million annual sales within the next 3 years. The CEO has been trying to find additional products that can leverage the current ABC employee skillset as well as the manufacturing facilities. As the controller of ABC Company, the CEO has come to you with a new opportunity that he’s been working on. The CEO would like to use the some of the shingle scrap materials to build cedar dollhouses. While this new product line would add additional raw materials and be more time-intensive to manufacture than the cedar shingles, this new product line will be able to leverage ABC’s existing manufacturing facilities as well as the current staff. Although this product line will require added expenses, it will provide additional revenue and gross profit to help reach the growth targets. The CEO is relying on you to help decide how this project can be afforded Provide details about the estimated product costs, what is needed to break even on the project, and what level of return this product is expected to provide. In order to help out the CEO, you need to prepare a six- to eight-page report that will contain the following information (including exhibits, but excluding your references and title page). Refer to the accompanying Excel spreadsheet (available through your online course) for some specific cost and profit information to complete the calculations. Final Paper Spreadsheet I. An overall risk profile of the company based on current economic and industry issues that it may be facing. II. Current company cash flow a. You need to complete a cash flow statement for the company using the direct method. b. Once you’ve completed the cash flow statement, answer the following questions: i. What does this statement of cash flow tell you about the sources and uses of the company? ii. Is there anything ABC Company can do to improve the cash flow? iii. Can this project be financed with current cash flow from the company? Why or why not? iv. If the company needs additional financing beyond what ABC Company can provide internally (either now or sometime throughout the life of the project), how would you suggest the company obtain the additional financing, equity or corporate debt, and why? III. Product cost: ABC Company believes that it has an additional 5,000 machine hours available in the current facility before it would need to expand. ABC Company uses machine hours to allocate the fixed factory overhead, and units sold to allocate the fixed sales expenses. ABC Company expects that it will take twice as long to produce the expansion product as it currently takes to produce its existing product. a. What is the product cost for the expansion product? b. By adding this new expansion product, it helps to absorb the fixed factory and sales expenses. How much cheaper does this expansion make the existing product? c. Assuming ABC Company wants a 40% gross margin for the new product, what selling price should it set for the expansion product? d. Assuming the same sales mix of these two products, what are the contribution margins and break-even points by product? IV. Potential investments to accelerate profit: ABC company has the option to purchase additional equipment that will cost about $42,000, and this new equipment will produce the following savings in factory overhead costs over the next five years: Year 1, $15,000 Year 2, $13,000 Year 3, $10,000 Year 4, $10,000 Year 5, $6,000 ABC Company uses the net-present-value method to analyze investments and desires a minimum rate of return of 12% on the equipment. a. What is the net present value of the proposed investment ignore income taxes and depreciation? b. Assuming a 5-year straight-line depreciation, how will this impact the factory’s fixed costs for each of the 5 years (and the implied product costs)? What about cash flow? c. Considering the cash flow impact of the equipment as well as the time-value of money, would you recommend that ABC Company purchases the equipment? Why or why not? V. Conclusion: a. What are the major risk factors that you see in this project? b. As the controller and a management accountant, what is your responsibility to this project? c. What do you recommend the CEO do? Writing the Final Paper 1. Must be six to eight double-spaced pages in length, and formatted according to APA style as outlined in the Ashford Writing Center. 2. Must include a title page with the following: a. Title of paper b. Student’s name c. Course name and number d. Instructor’s name e. Date submitted 3. Must begin with an introductory paragraph that has a succinct thesis statement. 4. Must address the topic of the paper with critical thought. 5. Must end with a conclusion that reaffirms your thesis. 6. Must document all sources in APA style, as outlined in the Ashford Writing Center. 7. Must include a separate reference page, formatted according to APA style as outlined in the Ashford Writing Center. Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment. ACC 206 Week 5 DQ 1 Long-term Decision Making Long-term Decision Making List a few of the issues and considerations businesses should have when it comes to the selection of long-term investments and how those issues impact the various financial statements. ACC 206 Week 5 DQ 2 Responsibilities in Management Accounting Responsibilities in Management Accounting Review the rights and responsibilities of Certified Management Accountants: http://www.imanet.org/PDFs/Public/CMA/RIghts_Responsibility_CMA.pdf What are some of the ethical responsibilities and obligations that management accountants have within an organization? Provide some examples. Are these responsibilities different than the obligations for financial accountants?

198 views • 15 slides

QNT 351 Genuine Education / snaptutorial.com

QNT 351 Final Exam Guide (New) For more classes visit www.snaptutorial.com Q1 The Director of Golf for a local course wants to study the number of rounds played by members on weekdays. He gathered the sample information shown below for 520 rounds. At the .05 significance level, is there a difference in the number of rounds played by day of the week? 2An auditor for American Health Insurance reports that 20% of policyholders submit a claim during the year. 15 policyholders are selected randomly. What is the probability that at least 3 of them submitted a claim the previous year? 3When a class interval is expressed as 100 up to 200, _________________________. 4A coffee manufacturer is interested in whether the mean daily consumption of regular-coffee drinkers is less than that of decaffeinated-coffee drinkers. A random sample of 50 regular-coffee drinkers showed a mean of 4.35 cups per day, with a standard deviation of 1.2 cups per day. A sample of 40 decaffeinated coffee drinkers showed a mean of 5.84 cups per day, with a standard deviation of 1.36 cups per day. What is your computed z-statistic? 5 You perform a hypothesis test at the .05 level of significance. Your computed p-value turns out to .042. What is your decision about the hypothesis? 6 In a distribution, the second quartile corresponds with the __________. 7 The MacBurger restaurant chain claims that the waiting time of customers for service is normally distributed, with a mean of 3 minutes and a standard deviation of 1 minute. The quality-assurance department found in a sample of 50 customers at the Warren Road MacBurger that the mean waiting time was 2.75 minutes. When you perform a test of hypothesis, what would be the resulting p-value? 8 The first card selected from a standard 52-card deck was a king. If it is returned to the deck, what is the probability that a king will be drawn on the second selection? 9 An example of a qualitative variable is _________________. 10 When statisticians analyze sample data in order to draw conclusions about the characteristics of a population, this is referred to as: 11 The ages of all the patients in the isolation ward of the hospital are 38, 26, 13, 41, and 22. What is the population standard deviation? 12 Consider the following regression analysis between sales (Y in $1,000) and social media advertising (X in dollars). 13 The tread life of tires mounted on light-duty trucks follows the normal probability distribution with a mean of 60,000 miles and a standard deviation of 4,000 miles. Suppose you bought a set of four tires, what is the likelihood the mean tire life of these four tires is between 57,000 and 63,000 miles? 14 University officials say that at least 70% of the voting student population supports a fee increase. If the 95% confidence interval estimating the proportion of students supporting the fee increase is [0.75, 0.85], what conclusion can be drawn? 15 A study by the National Park Service revealed that 50% of the vacationers going to the Rocky Mountain region visit Yellowstone Park, 40% visit the Grand Tetons, and 35% visit both. What is the probability that a vacationer will visit at least one of these magnificent attractions? 16 The distribution of a sample of the outside diameters of PVC pipes approximates a symmetrical, bell-shaped distribution. The arithmetic mean is 14.0 inches, and the standard deviation is 0.1 inches. About 68% of the outside diameters lie between what two amounts? 17 A group of women tried five brands of fingernail polish and ranked them according to preference. What level of measurement is this? 18 What is the range of values for a coefficient of correlation? 19 Which approach to probability assumes that the events are equally likely? 20 What is the median of 26, 30, 24, 32, 32, 31, 27, and 29? 21 Sales at a fast-food restaurant average $6,000 per day. The restaurant decided to introduce an advertising campaign to increase daily sales. To determine the effectiveness of the advertising campaign, a sample of 49 days of sales was taken. It found that the average daily sales were $6,400 per day. From past history, the restaurant knew that its population standard deviation is about $1,000. The value of the test statistic is _______. 22 The mean of a normal distribution is 400 pounds. The standard deviation is 10 pounds. What is the probability of a weight between 415 pounds and the mean of 400 pounds? 23 Which of the following is true regarding the normal distribution? 24 A time series trend equation for Hammer Hardware is Yu2019 = 5.6 1.2t, where sales are in millions of dollars and t increases by one unit for each year. If the value of sales in the base year of 2016 is $5.6 million, what would be the estimated sales amount for 2018? 25 A research firm conducted a survey to determine the mean amount steady smokers spend on cigarettes during a week. A sample of 64 smokers revealed that uf7c3 = $20 and S = $5. What is the 95% confidence interval for u03bc? 26 A weight-loss company wants to statistically prove that its methods work. They randomly selected 10 clients who had been on the weight loss program for between 55 and 65 days. They looked at their beginning weights and their current weight. The statistical test they should utilize is: 27 As the size of the sample increases, what happens to the shape of the distribution of sample means? 28 Each month the National Association of Purchasing Managers publishes the NAPM index. One of the questions asked on the survey to purchasing agents is: Do you think that the economy is expanding? Last month, of the 300 responses, 160 answered u201cyesu201d to the question. This month, 170 of the 290 responses indicated that the economy is expanding. If youu2019re testing to find if a larger proportion of agents believe that the economy is expanding this month, what is your computed test statistic? 29 A group of 100 students was surveyed about their interest in a new International Studies program. Interest was measured in terms of high, medium, or low. In the study, 30 students responded high interest, 40 students responded medium interest, and 30 students responded low interest. What is the relative frequency of students with high interest? 30 A hypothesis regarding the weight of newborn infants at a community hospital is that the mean is 6.6 pounds. A sample of seven infants is randomly selected and their weights at birth are recorded as 9.0, 7.3, 6.0, 8.8, 6.8, 8.4, and 6.6 pounds. What is the alternate hypothesis? ***************************************************** QNT 351 Final Exam Guide For more classes visit www.snaptutorial.com 1) The main purpose of descriptive statistics is to 2) The general process of gathering, organizing, summarizing, analyzing, and interpreting data is called 3) The performance of personal and business investments is measured as a percentage, return on investment. What type of variable is return on investment? 4) What type of variable is the number of robberies reported in your city? 5) What level of measurement is the number of auto accidents reported in a given month? 6) The names of the positions in a corporation, such as chief operating officer or controller, are examples of what level of measurement? 7) Shoe sizes, such as 7B, 10D, and 12EEE, are examples of what level of measurement? 8) Monthly commissions of first-year insurance brokers are $1,270, $1,310, $1,680, $1,380, $1,410, $1,570, $1,180, and $1,420. These figures are referred to as 9) A small sample of computer operators shows monthly incomes of $1,950, $1,775, $2,060, $1,840, $1,795, $1,890, $1,925, and $1,810. What are these ungrouped numbers called? 10) The sum of the deviations of each data value from this measure of central location will always be 0 11) For any data set, which measures of central location have only one value? 12) A sample of single persons receiving social security payments revealed these monthly benefits: $826, $699, $1,087, $880, $839, and $965. How many observations are below the median? 13) A dot plot shows 14) The test scores for a class of 147 students are computed. What is the location of the test score associated with the third quartile? 15) The National Center for Health Statistics reported that of every 883 deaths in recent years, 24 resulted from an automobile accident, 182 from cancer, and 333 from heart disease. Using the relative frequency approach, what is the probability that a particular death is due to an automobile accident? 16) If two events A and B are mutually exclusive, what does the special rule of addition state? 17) A listing of all possible outcomes of an experiment and their corresponding probability of occurrence is called a 18) The shape of any uniform probability distribution is 19) The mean of any uniform probability distribution is 20) For the normal distribution, the mean plus and minus 1.96 standard deviations will include about what percent of the observations? 21) For a standard normal distribution, what is the probability that z is greater than 1.75? 22) A null hypothesis makes a claim about a 23) What is the level of significance? 24) Suppose we test the difference between two proportions at the 0.05 level of significance. If the computed z is -1.07, what is our decision? 25) Which of the following conditions must be met to conduct a test for the difference in two sample means? 26) Which of the following statements about the two sample sizes is NOT true? Assume the population standard deviations are equal. 27) What is the chart called when the paired data (the dependent and independent variables) are plotted? 28) What is the variable used to predict the value of another called? 29) Twenty randomly selected statistics students were given 15 multiple-choice questions and 15 open-ended questions, all on the same material. The professor was interested in determining on which type of questions the students scored higher. This experiment is an example of 30) The measurements of weight of 100 units of a product manufactured by two parallel processes have same mean but the standard of process A is 15 while that of B is 7. What can you conclude? ***************************************************** QNT 351 Week 1 Connect Problems For more classes visit www.snaptutorial.com QNT 351 Week 1 Connect Problem 1. Which of the following is an example of a continuous variable? 2. The incomes of 50 loan applicants are obtained. Which level of measurement is income? 3. The members of each basketball team wear numbers on their jerseys. What scale of measurement are these numbers considered? 4. The reported unemployment is 5.5% of the population. What measurement scale is used to measure unemployment? 5. The Nielsen Ratings break down the number of people watching a particular television show by age. What level of measurement is age? 6. An example of a qualitative variable is _________________. 7. Two thousand two hundred frequent business travelers are asked which midwestern city they prefer: Indianapolis, Saint Louis, Chicago, or Milwaukee. 112 liked Indianapolis best, 452 liked Saint Louis, 1295 liked Chicago, and the remainder preferred Milwaukee. Develop a frequency table and a relative frequency table to summarize this information. 8. The Cambridge Power and Light Company selected a random sample of 20 residential customers. Following are the amounts, to the nearest dollar, the customers were charged for electrical service last month: a. Compute the arithmetic mean.(Round your answer to 2 decimal places.) b. Indicate whether it is a statistic or a parameter. 9. Consider these five values a population: 6, 3, 7, 3, and 7. a. Determine the mean of the population. b. Determine the variance of the population. 10. An investor buys 100 shares of AT&T stock and records its price change daily. Which concept of probability would you use to estimate the probability of an individual event? ***************************************************** QNT 351 Week 1 DQ 1 For more classes visit www.snaptutorial.com Week 1 DQ1 Where would you see descriptive statistics used in your work place? ***************************************************** QNT 351 Week 1 DQ 2 For more classes visit www.snaptutorial.com Week 1 DQ2 How would you define dependent and independent variables? What is their significance in research? Explain with examples. ***************************************************** QNT 351 Week 1 DQ 3 For more classes visit www.snaptutorial.com Week 1 DQ3 Develop five demographic questions to measure gender, age, years of experience, level of education, and ethnicity. Identify the level of measurement used for each ***************************************************** QNT 351 Week 1 DQ 4 For more classes visit www.snaptutorial.com Week 1 DQ4 How would you define a variable? What is the difference between a dependent and independent variable? Do you think both variables are used in every research? Explain why or why not. Provide examples. ***************************************************** QNT 351 Week 1 DQ 5 For more classes visit www.snaptutorial.com Week 1 DQ5 What is the importance of statistics in business decision making? Describe a business situation where statistics was used in making a decision. ***************************************************** QNT 351 Week 1 DQ 6 For more classes visit www.snaptutorial.com Week 1 DQ6 What are the four data measurement scales? Provide two examples and explain the importance of each in business research. ***************************************************** QNT 351 Week 1 Individual Assignment Statistics in Business (2 Sets) For more classes visit www.snaptutorial.com This tutorial contains 2 different Sets of papers Define statistics. Identify different types of statistics. Describe the role of statistics in business decision making. Write a 300-word summary providing at least three examples or problem situations in which statistics was used or could be used. ***************************************************** QNT 351 Week 1 Introduction to Statistical Thinking Worksheet For more classes visit www.snaptutorial.com Complete the Introduction to Statistical Thinking Worksheet. Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. 1. There are 23 people at a party. Explain what the probability is that any two of them share the same birthday. 2. A cold and flu study is looking at how two different medications work on sore throats and fever. Results are as follows: u2022 Sore throat - Medication A: Success rate - 90% (101 out of 112 trials were successful) u2022 Sore throat - Medication B: Success rate - 83% (252 out of 305 trials were successful) u2022 Fever - Medication A: Success rate - 71% (205 out of 288 trials were successful) u2022 Fever - Medication B: Success rate - 68% (65 out of 95 trials were successful) Analyze the data and explain which one would be the better medication for both a sore throat and a fever. 3. The United States employed a statistician to examine damaged planes returning from bombing missions over Germany in World War II. He found that the number of returned planes that had damage to the fuselage was far greater than those that had damage to the engines. His recommendation was to enhance the reinforcement of the engines rather than the fuselages. If damage to the fuselage was far more common, explain why he made this recommendation. ***************************************************** QNT 351 Week 2 Connect Problems For more classes visit www.snaptutorial.com QNT 351 Week 2 Connect Problem 1. The director of admissions at Kinzua University in Nova Scotia estimated the distribution of student admissions for the fall semester on the basis of past experience. a. What is the expected number of admissions for the fall semester? b. Compute the variance and the standard deviation of the number of admissions. 2. The Internal Revenue Service is studying the category of charitable contributions. A sample of 28 returns is selected from young couples between the ages of 20 and 35 who had an adjusted gross income of more than $100,000. Of these 28 returns, 5 had charitable contributions of more than $1,000. Suppose 4 of these returns are selected for a comprehensive audit. a. You should use the hyper geometric distribution is appropriate. Because b. What is the probability exactly one of the four audited had a charitable deduction of more than $1,000? c. What is the probability at least one of the audited returns had a charitable contribution of more than $1,000? 3. According to the "January theory," if the stock market is up for the month of January, it will be up for the year. If it is down in January, it will be down for the year. According to an article in The Wall Street Journal, this theory held for 28 out of the last 34 years. Suppose there is no truth to this theory; that is, the probability it is either up or down is 0.5. What is the probability this could occur by chance? 4. Customers experiencing technical difficulty with their internet cable hookup may call an 800 number for technical support. It takes the technician between 150 seconds and 14 minutes to resolve the problem. The distribution of this support time follows the uniform distribution. a. What are the values for a and b in minutes? b-1. What is the mean time to resolve the problem? b-2. What is the standard deviation of the time? c. What percent of the problems take more than 5 minutes to resolve? d. Suppose we wish to find the middle 50% of the problem-solving times. What are the end points of these two times? 5. A normal population has a mean of 21 and a standard deviation of 6. a. Compute the z value associated with 24. b. What proportion of the population is between 21 and 24? c. What proportion of the population is less than 17? 6. Assume that the hourly cost to operate a commercial airplane follows the normal distribution with a mean of $2,100 per hour and a standard deviation of $250. What is the operating cost for the lowest 3% of the airplanes? 7. The manufacturer of a laser printer reports the mean number of pages a cartridge will print before it needs replacing is 12,400. The distribution of pages printed per cartridge closely follows the normal probability distribution and the standard deviation is 620 pages. The manufacturer wants to provide guidelines to potential customers as to how long they can expect a cartridge to last. How many pages should the manufacturer advertise for each cartridge if it wants to be correct 95 percent of the time? 8. A study of long-distance phone calls made from General Electric Corporate Headquarters in Fairfield, Connecticut, revealed the length of the calls, in minutes, follows the normal probability distribution. The mean length of time per call was 5.20 minutes and the standard deviation was 0.70 minutes. a. What fraction of the calls last between 5.20 and 6.00 minutes? b. What fraction of the calls last more than 6.00 minutes? c. What fraction of the calls last between 6.00 and 7.00 minutes? d. What fraction of the calls last between 5.00 and 7.00 minutes? e. As part of her report to the president, the director of communications would like to report the length of the longest (in duration) 4 percent of the calls. What is this time? 9. A population consists of the following five values: 13, 15, 17, 19, and 22. a. List all samples of size 3, and compute the mean of each sample. b. Compute the mean of the distribution of sample means and the population mean. 10. The mean age at which men in the United States marry for the first time follows the normal distribution with a mean of 24.4 years. The standard deviation of the distribution is 2.6 years. For a random sample of 57 men, what is the likelihood that the age at which they were married for the first time is less than 24.9 years? ***************************************************** QNT 351 Week 2 DQ 1 For more classes visit www.snaptutorial.com Week 2 DQ1 Can mean, median, or mode be calculated from all statistical data? Explain why or why not. When is the mean the best measure of central tendency? When is the median the best measure of central tendency? ***************************************************** QNT 351 Week 2 DQ 2 For more classes visit www.snaptutorial.com Week 2 DQ2 Describe a business situation, other than what has already been selected by fellow students or selected from the team assignment, where mean and standard deviation can be used in decision making. Describe how calculation of mean and standard deviation can help in making a decision. ***************************************************** QNT 351 Week 2 DQ 3 For more classes visit www.snaptutorial.com Week 2 DQ3 What level of data is a telephone number? Explain. ***************************************************** QNT 351 Week 2 DQ 4 For more classes visit www.snaptutorial.com Week 2 DQ4 Does all data have a mean, median, or mode? Why or why not? When is the mean the best measure of central tendency? When is the median the best measure of central tendency? ***************************************************** QNT 351 Week 2 DQ 5 For more classes visit www.snaptutorial.com Week 2 DQ5 Why is the population shape a concern when estimating a mean? What effect does sample size, n, have on the estimate of the mean? ***************************************************** QNT 351 Week 2 Excel Problem Graphical Technique For more classes visit www.snaptutorial.com Question 1 Plot a 100% stacked column chart for television sales by year. U.S. Television Sales, 2002 - 2005 ($ thousands) Projection TV LCD TV Plasma TV 2002 3,574 246 515 2003 4,351 664 1,590 2004 6,271 1,579 2,347 2005 5,320 3,295 4,012 Question 2 In a 2013 survey of employees conducted by Financial Finesse Inc., employees were asked about their overall financial stress levels. The following table shows the results of this survey (www.financialfinesse.com) Question 3 Given below are the ratings of the overall dining experience (Outstanding, Very Good, Good, Average, or Poor) of 30 randomly selected patrons at a restaurant on a Saturday evening. a) Using the Pivot table in Excel, construct a frequency distribution. Frequency Distribution is a table with two columns - Ratings and Frequency. b) Plot a bar chart using Pivot Chart. c) Plot a pie chart using Pivot Chart. Question 4 Given below is the revenue data for an organization. Plot Revenue on a line chart. Month Revenue Jan $4,510 Feb $10,430 Mar $8,950 Apr $12,300 May $5,300 Jun $12,430 Jul $11,900 Aug $12,230 Sep $10,480 Oct $10,500 Nov $12,870 Dec $11,400 Question 5 Refer to the chart below and answer the questions a. What is the name given to this type of chart? b. b. Suppose that 1,000 graduates will start a new job shortly after graduation. Estimate the number of graduates, whose first contact for employment occurred through networking and other connections ***************************************************** QNT 351 Week 2 Learning Team Assignment Data Collection (2 Sets) For more classes visit www.snaptutorial.com This tutorial contains 2 different Sets of papers Discuss with your team whether you have data from RES/351, and if your team would like to use one team memberu2019s data for the Learning Team assignments in this course. If using data from RES/351: Resources: Data collected from RES/351 Prepare a 700- to 1,050-word written report along with a 5- to 7-slide Microsoftu00ae PowerPointu00ae presentation for the senior management team or stakeholders of your RES/351 research project to present your findings. Address the following: u2022tPresent the chosen situation as an overviewu2014problem, purpose, research questions, and hypotheses. u2022tDescribe and the instrument used for data collection. u2022tIdentify types of datau2014quantitative, quantitative, or bothu2014and how the data is collected. u2022tIdentify the level of measurement for each of the variables involved in the study. u2022tCode the data if you have not done so. Describe how the data is coded and evaluate the procedure used. u2022tClean the data by eliminating the data input errors made. u2022tDraw conclusions about appropriateness of data to meet the purpose of the study. If you decide not to use your own data, you can use the Ballard Integrated Managed Services, Inc., case study overview: Resources: University of Phoenix Material: Ballard Integrated Managed Services, Inc., Part 1 Review the Ballard Integrated Managed Services, Inc. (BIMS) case study overview. Prepare a 700- to 1,050-word written report along with a 5- to 7-slide Microsoftu00ae PowerPointu00ae presentation for the senior management team to present your findings (see Exhibit D for the data set of the second survey). Address the following: u2022tPresent the BIMS situation as an overviewu2014problem, purpose, research questions, and hypotheses. u2022tDescribe the instrument used for data collection. u2022tIdentify types of data collectedu2014quantitative, qualitative, or bothu2014and how the data is collected. u2022tIdentify the level of measurement for each of the variables involved in the study. u2022tCode the data if you have not done so. Describe how the data is coded and evaluate the procedure used. u2022tClean the data by eliminating the data input errors made. u2022tDraw conclusions about appropriateness of data to meet the purpose of the study. Note. As consultants to BIMS, your Learning Team is expected to prepare and deliver a professional product addressing the client's needs. ***************************************************** QNT 351 Week 2 Probability Worksheet For more classes visit www.snaptutorial.com Complete the Probability Worksheet. Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. Maximum and Minimum Temperatures Search the Internet for U.S. climate data. Choose the city in which you live. Click on the tab that reads u201cDaily.u201d 1.tPrepare a spreadsheet with three columns: Date, High Temperature, and Low Temperature. List the past 60 days for which data is available. 2.tPrepare a histogram for the data on high temperatures and comment on the shape of the distribution as observed from these graphs. 3.tCalculate uf7c3 and S. 4.tWhat percentage of the high temperatures are within the interval uf7c3 u2013 S to uf7c3 S? 5.tWhat percentage of the high temperatures are within the interval uf7c3 u2013 2S to uf7c3 2S? 6.tHow do these percentages compare to the corresponding percentages for a normal distribution (68.26% and 95.44%, respectively)? 7.tRepeat Parts 2 to 6 for the minimum temperatures on your spreadsheet. Would you conclude that the two distributions are normally distributed? Why or why not? ***************************************************** 8.t QNT 351 Week 2 Team Assignment Descriptive Statistics Real Estate Data Part 1 (New) For more classes visit www.snaptutorial.com Search the Internet for a realty site. Select a hometown of someone on your team in the search section on the website you have chosen. When all of the listings populate, make sure that the sort criteria reads "New Listings." This ensures that you are searching a random cross-section of listings rather than favoring one price range. Review the new listings that populate. Create an Excelu00ae spreadsheet with 4 columns of the first 100 single family homes listed, not including condominiums or townhouses. Include each of the following categories in the spreadsheet: Property address, listing price, square footage, and number of bedrooms. Prepare a frequency distribution for listing prices, including relative frequencies. Create your frequency distribution as identified in Chapters 2, 3, and 4. Generate a histogram from your frequency distribution, again making sure you are consistent with the rules discussed in Chapter 2. Summarize your findings from your frequency distribution and your histogram. Create either a pie chart or a bar graph of the number of bedrooms in your 100 homes. Evaluate your visual aid. Calculate measures of central tendency for both listing prices and square footages. Those measures are mean, median, and mode. Determine the quartiles for both listing prices and square footages. Calculate measures of dispersion for both listing prices and square footages. Those measures are range, variance, and standard deviation. Apply Chebyshev's Theorem and the Empirical Rule to both sets of data. Compare your findings with your actual data. Conclude whether Chebyshev's or Empirical Rule is more accurate with each of listing prices and square footages. Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. ***************************************************** QNT 351 Week 3 Connect Problems For more classes visit www.snaptutorial.com Award: 10 out of 10.00 points A sample of 43 observations is selected from a normal population. The sample mean is 30, and the population standard deviation is 3. Conduct the following test of hypothesis using the 0.05 significance level. a. Is this a one- or two-tailed test? b. What is the decision rule? (Round your answer to 3 decimal places.) c. What is the value of the test statistic? (Round your answer to 2 decimal places.) d. What is your decision regarding H0? e. What is the p-value? (Round your answer to 4 decimal places.) 2.At the time she was hired as a server at the Grumney Family Restaurant, Beth Brigden was told, u201cYou can average $86 a day in tips.u201d Assume the population of daily tips is normally distributed with a standard deviation of $3.81. Over the first 48 days she was employed at the restaurant, the mean daily amount of her tips was $87.07. At the 0.02 significance level, can Ms. Brigden conclude that her daily tips average more than $86? a. State the null hypothesis and the alternate hypothesis. b. State the decision rule. c. Compute the value of the test statistic. (Round your answer to 2 decimal places.) d. What is your decision regarding H0? e. What is the p-value? (Round your answer to 4 decimal places.) 3.The Rocky Mountain district sales manager of Rath Publishing Inc., a college textbook publishing company, claims that the sales representatives make an average of 43 sales calls per week on professors. Several reps say that this estimate is too low. To investigate, a random sample of 41 sales representatives reveals that the mean number of calls made last week was 44. The standard deviation of the sample is 2.9 calls. Using the 0.100 significance level, can we conclude that the mean number of calls per salesperson per week is more than 43? 1. Compute the value of the test statistic. (Round your answer to 3 decimal places.) 2. What is your decision regarding H0? 4. Award: 10 out of 10.00 points A United Nations report shows the mean family income for Mexican migrants to the United States is $27,150 per year. A FLOC (Farm Labor Organizing Committee) evaluation of 30 Mexican family units reveals a mean to be $29,500 with a sample standard deviation of $11,150. Does this information disagree with the United Nations report? Apply the 0.01 significance level. a. State the null hypothesis and the alternate hypothesis. b. State the decision rule for .01 significance level. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) c. Compute the value of the test statistic. (Round your answer to 2 decimal places.) d. Does this information disagree with the United Nations report? Apply the 0.01 significance level. 5.The following information is available. H0 : u03bc u2265 220 H1 : u03bc < 220 A sample of 64 observations is selected from a normal population. The sample mean is 215, and the population standard deviation is 15. Conduct the following test of hypothesis using the .025 significance level. a. Is this a one- or two-tailed test? b. What is the decision rule? (Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places.) c. What is the value of the test statistic? (Negative amount should be indicated by a minus sign. Round your answer to 3 decimal places.) d. What is your decision regarding H0? e. What is the p-value? (Round your answer to 4 decimal places.) 6.Given the following hypotheses: H0 : u03bc u2264 10 H1 : u03bc > 10 A random sample of 10 observations is selected from a normal population. The sample mean was 12 and the sample standard deviation 3. Using the .05 significance level: a. State the decision rule. (Round your answer to 3 decimal places.) b. Compute the value of the test statistic. (Round your answer to 3 decimal places.) c. What is your decision regarding the null hypothesis? 7.Given the following hypotheses: H0 : u03bc = 400 H1 : u03bc u2260 400 A random sample of 12 observations is selected from a normal population. The sample mean was 407 and the sample standard deviation 6. Using the .01 significance level: a. State the decision rule. (Negative amount should be indicated by a minus sign. Round your answers to 3 decimal places.) b. Compute the value of the test statistic. (Round your answer to 3 decimal places.) c. What is your decision regarding the null hypothesis? ******************************************************** QNT 351 Week 3 DQ 1 For more classes visit www.snaptutorial.com Week 3 DQ1 What are the differences between probability and coincidence? Can the probability be more than 1 or less than 0? Explain why or why not. ***************************************************** QNT 351 Week 3 DQ 2 For more classes visit www.snaptutorial.com Week 3 DQ2 What is the role of probability concepts in business decision-making? Provide specific examples. ***************************************************** QNT 351 Week 3 DQ 3 For more classes visit www.snaptutorial.com Week 3 DQ3 What are the basic differences between a discrete and a continuous distribution? ***************************************************** QNT 351 Week 3 DQ 4 For more classes visit www.snaptutorial.com Week 3 DQ4 What are the characteristics of standard normal distribution? Explain how to calculate the z-test static. Explain how a z-value is used to calculate the area under the distribution and the meaning of P(0 to z) when z = 1.96. ***************************************************** QNT 351 Week 3 Excel Problems Measuring Salespeople Performance For more classes visit www.snaptutorial.com Week A B C D 1 1774 2205 1330 1402 2 1808 1507 1295 1665 3 1890 2352 1502 1530 4 1932 1939 1104 1826 5 1855 2052 1189 1703 6 1726 1630 1441 1498 Interpretation of Minimum and Maximum Interpretation of Mean and Median Interpretation of Standard Deviation and Variance Interpretation of the First and Third Quartiles ***************************************************** QNT 351 Week 3 Individual Assignment Real Estate Data For more classes visit www.snaptutorial.com Resources: Appendix A1 at the end of Basic Statistics for Business and Economics Answer question 68 in the Data Set Exercises from Ch. 3 of Basic Statistics for Business and Economics. Answer question 34 in the Data Set Exercises from Ch. 4 of Basic Statistics for Business and Economics. ***************************************************** QNT 351 Week 3 Team Assignment Sampling Distributions Real Estate Part 2 (New) For more classes visit www.snaptutorial.com Use the real estate data that you used for your learning team project that was due in Week 2. Complete the Sampling Distributions - Real Estate Part 2 worksheet. Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. 1.tReview the data and for the purpose of this project please consider the 100 listing prices as a population. u2022 Explain what your computed population mean and population standard deviation were. 2. Divide the 100 listing prices into 10 samples of n=10 each. Each of your 10 samples will tend to be random if the first sample includes houses 1 through 10 on your spreadsheet, the second sample consists of houses 11 through 20, and so on. u2022 Compute the mean of each of the 10 samples and list them: 3. Compute the mean of those 10 means. u2022 Explain how the mean of the means is equal, or not, to the population mean of the 100 listing prices from above. 4. Compute the standard deviation of those 10 means and compare the standard deviation of the 10 means to the population standard deviation of all 100 listing prices. u2022 Explain why it is significantly higher, or lower, than the population standard deviation. 5. Explain how much more or less the standard deviation of sample means was than the population standard deviation. According to the formula for standard deviation of sample means, it should be far less. (That formula is u03c3uf7c3 = u03c3/u221an = u03c3/u221a10 = u03c3/3.16 ) Does your computed u03c3uf7c3 agree with the formula? ***************************************************** QNT 351 Week 3 Team Assignment Summarizing and Presenting Data (2 Sets) For more classes visit www.snaptutorial.com This tutorial contains 2 different Sets of papers If using RES/351 data: Revise the report submitted in Week Two based on the feedback provided by the instructor in the team assignment, and insight gained by reading. Summarize the data collected using descriptive statistics. Descriptive statistics should be in the forms of frequency distribution table, measures of mean, median, mode, standard deviation, and graphical display of data. Summarize the statistics in relation to the problem selected and research questions and draw conclusions. Prepare a 1,050- to 1,750-word report of conclusions drawn from the data and make recommendations to the management. Support recommendations by citing literature consistent with APA guidelines. If using the Ballard Integrated Managed Services, Inc., (BIMS) case study overview: Revise the report submitted in Week Two based on the feedback provided by the instructor in the team assignment, and insight gained by reading. Analyze the data included in BIMS case study Part 1 by computing descriptive statistics in the form of tables, charts, measures of central tendency, and variability. Prepare a 1,050- to 1,750-word report of conclusions drawn from the data and make recommendations to the management. Support recommendations by citing literature consistent with APA guidelines. ***************************************************** QNT 351 Week 4 Connect Problems For more classes visit www.snaptutorial.com QNT 351 Week 4 Connect Problem 1) The Production department of Celitronics International wants to explore the relationship between the number of employees who assemble a subassembly and the number produced. As an experiment, 2 employees were assigned to assemble the subassemblies. They produced 13 during a one-hour period, then 4 employees assembled them. They produced 22 during a one hour period. The complete set of paired observation follows a) The dependent variable is production; that is, it is assumed that different levels of production result from a different number of employees. b) A scatter diagram is provided below. Based on it, does there appear to be any relationship between the number of assemblers and production? c) Compute the correlation coefficient. 2) The following sample observation were randomly selected. X : 4 5 3 6 10 Y : 9.8 10.6 8 15.4 19.6 a) The regression equation is Y^ =? b) When X is 5.5 this gives Y^=? 3) Bi-io Appliance Super-store has outlets in several large metropolitian areas in New England. The general sales manager aired a commercial for a digital camera on selected local TV stations prior tp a sale starting on Saturday and editing Sunday. She obtained the information for Saturday-Sunday digital camera sales at the various outlets and paired it with number to times the advertisement was shown on the local TV stations. The Purpose is to find whether there is any relationship between the number of times the advertisement was aired and digital camera sales. The pairings are: a) What is the dependent variable? b) Determine the correlation coefficient c) Interpret these statistical measures. 4) The owner of Maumee Ford-Mercury-Volvo wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at the dealership during the last year. a) If we want to estimate selling price on the basis of the age car, which variable is the dependent variable and which is the independent variable? b) Determine the correlation coefficient? Determine the coefficient of determination? c) Interpret the correlation coefficient. Does it surprise you that the correlation coefficient is negative? 5) Pennsylvania refining Company is studying the relationship between the pump price of gasoline and the number of gallons sold. For a sample of 20 stations last Tuesday the correlation was 78. At the 0.1 significance level, is the correlation in the population greater than zero? ***************************************************** QNT 351 Week 4 DQ 1 For more classes visit www.snaptutorial.com Week 4 DQ1 What are some terms related to hypothesis testing with which you are already familiar? Why do null and alternative hypotheses have to be mutually exclusive? ***************************************************** QNT 351 Week 4 DQ 2 For more classes visit www.snaptutorial.com Week 4 DQ2 Why does the significance level differ among industries? Will the null hypothesis be more likely to be rejected at u03b1 = 0.01 than u03b1 = 0.10? As the significance level increases to u03b1 = 0.10 from u03b1 = 0.01, which type error is more likely to occur? What can be done to reduce the likelihood of incurring this error? ***************************************************** QNT 351 Week 4 DQ 3 For more classes visit www.snaptutorial.com Week 4 DQ3 Please explain the five steps used in hypothesis testing. How does the five-step procedure for hypothesis testing differ when comparing two groups using a t- or z-test? How is the process similar? ***************************************************** QNT 351 Week 4 DQ 4 For more classes visit www.snaptutorial.com Week 4 DQ4 Please explain terms related to hypothesis testing; please explain null and alternate hypotheses, explain the difference between two different test statistics, then define the equations used in both. Why do null and alternative hypotheses have to be mutually exclusive? ***************************************************** QNT 351 Week 4 Excel Problems Measures of Relative Standing and ProbabilityDistribution For more classes visit www.snaptutorial.com Problem 1 Figure below gives the boxplots comparing the base yearly salaries of employeesin marketing and employees in research for a large company. Identify the five number summaries. for each profession. Interpret them like we did in the class. Problem 2 An insurance company determines that in every 100 claims, 4 are fraudulent. What is the probability that the next claim the company processes will be fraudulent? Problem 3 A review of emergency room records at rural Millard FellmoreMemorial Hospital was performed to determine the probability distribution of the number of patients entering the emergency room during a 1-hour period. The following table lists this probability distribution. Problem 4 Find the missing probability in the following probability distribution. Problem 5 Determine whether the distribution given below are valid probability distributions or not. Problem 6 Determine whether the random variable x is discrete or continuous a. Let x represent the number of pumps in use at a gas station b. Let x represent the weight of a truck at a weigh station ***************************************************** QNT 351 Week 4 Individual Assignment Real Estate Data For more classes visit www.snaptutorial.com Resources: Appendix A1 at the end of Basic Statistics for Business and Economics Answer question 60 (both parts a. and b.) in the Data Set Exercises from Ch. 6 of Basic Statistics for Business and Economics. Answer question 54 (both parts a. and b.) in the Data Set Exercises from Ch. 7 of Basic Statistics for Business and Economics. ***************************************************** QNT 351 Week 4 Learning Team Reflection (2 Sets) For more classes visit www.snaptutorial.com QNT 351 Week 4 Learning Team Reflection This tutorial contains 2 different sets Discuss the following with your Learning Team: u2022tThe steps in testing a research hypothesis u2022tComparing the means of two or more groups u2022tCalculating the correlation between two variables Include the topics you feel comfortable with, any topics you struggled with, and how the weekly topics relate to application in your field. Prepare a 350- to 1,050-word paper detailing the findings of your discussion. Click the Assignment Files tab to submit your assignment. ***************************************************** QNT 351 Week 4 Two Population Means Worksheet For more classes visit www.snaptutorial.com A tomato farmer with a very large farm of approximately 2200 acres had heard about a new type of rather expensive fertilizer which would supposedly significantly increase his production. The frugal farmer wanted to test the new fertilizer before committing the large investment required to fertilize a farm of his size. He therefore selected 15 parcels of land on his property and divided them each into two portions. He bought just enough of the new fertilizer to spread over one half of each parcel and then spread the old fertilizer over the other half of each parcel. His yields in pounds per tomato plant were as follows: What if you were the fertilizer sales representative and your job was to prove the superiority of the new product to the farmer? (1) You should start by running the same test he did in which he came to the decision that he could not conclude a difference. (2) Perform the test as it should have been done and find if you come to a different conclusion. (3) Explain why the results were different and why your test was a stronger and more reliable test. ***************************************************** QNT 351 Week 5 Individual Assignment Real Estate Data For more classes visit www.snaptutorial.com Resources: Appendix A1 at the end of Basic Statistics for Business and Economics Answer question 58 in the Data Set Exercises from Ch. 10 of Basic Statistics for Business and Economics. Answer question 62 in the Data Set Exercises from Ch. 13 of Basic Statistics for Business and Economics. ***************************************************** QNT 351 Week 5 Learning Team Assignment Analyzing and Interpreting Data Paper and Presentation For more classes visit www.snaptutorial.com If using RES/351 data: Ask your instructor for specific information regarding the analysis you are required to perform for your data set. Combine your Week Two Learning Team assignment and Week Three findings with Week Five findings and make a recommendation to the research problem. Use the statistical tables given in the appendices of the textbook and a statistical analysis application: a Microsoftu00ae Excelu00ae spreadsheet, Minitabu00ae statistical software, or SPSSu2122 software. Prepare a 1,050- to 1,750-word written report along with a 7- to 9-slide Microsoftu00ae PowerPointu00ae presentation for the senior management team to present your findings. If using the Ballard Integrated Managed Services, Inc. (BIMS) case study overview: Read the University of Phoenix Material: Ballard Integrated Managed Services, Inc., Part 2. Your team acts as a consultant group that analyzes and interprets this second set of data. The intent is to increase senior managementu2019s understanding of the sources of employee dissatisfaction and to create a model that predicts employee resignation. Combine your Week Two Learning Team assignment and Week Three findings with Week Five findings and make a recommendation to BIMS. Use the statistical tables given in the appendices of the textbook and a statistical analysis application: a Microsoftu00ae Excelu00ae spreadsheet, Minitabu00ae statistical software, or SPSSu2122 software. Prepare a 1,050- to 1,750-word written report along with a 7- to 9-slide Microsoftu00ae PowerPointu00ae presentation for the senior management team to present your findings (see Exhibit D for the data set of the second survey). Note. As consultants to BIMS, your Learning Team is expected to prepare and deliver a professional product addressing the clientu2019s needs. ***************************************************** QNT 351 Week 5 Team Assignment Real Estate Regression Exercise (New) For more classes visit www.snaptutorial.com Complete the Real Estate Regression Exercise. Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city youu2019ve been researching. You have data on square footages and listing prices for 100 homes. 1. Which variable is the independent variable (x) and which is the dependent variable (y)? 2. Click on any cell. Click on Insertu2192Scatteru2192Scatter with markers (upper left). To add a trendline, click Toolsu2192Layoutu2192Trendlineu2192Linear Trendline Does the scatterplot indicate observable correlation? If so, does it seem to be strong or weak? In what direction? 3. Click on Datau2192Data Analysisu2192Regressionu2192OK. Highlight your data (including your two headings) and input the correct columns into Input Y Range and Input X Range, respectively. Make sure to check the box entitled u201cLabelsu201d. (a) What is the Coefficient of Correlation between square footage and listing price? (b) Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not? (c) What proportion of the variation in listing price is determined by variation in the square footage? What proportion of the variation in listing price is due to other factors? (d) Check the coefficients in your summary output. What is the regression equation relating square footage to listing price? (e) Test the significance of the slope. What is your t-value for the slope? Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a significant relationship between the variables? (f) Using the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet? *****************************************************

465 views • 44 slides

Extract ASDA Grocery Prices and Stock Available Data

Extract ASDA Grocery Prices and Stock Available Data

Presentation Transcript

Case Study Building an Online Grocery Business: The Case of ASDA

Your Role in ASDA Communications

ACC 206 Complete Class All Assignments ,DQs and Problems

Week 8 Homework â€“ Chapter 20: Problems 3(a-c), 5(a-c), 8(a-c), 9(a-d), and 10(a-d)

Ganoderma extract Wholesale in India

All History Notes At One Place PDF Download//Examclear.com

Stock Tips that should be followed by New Investors

A Right To Data Is Meaningless Without Knowledge Of What Is Available

How to Start Grocery eCommerce Business?

QNT 351 Genuine Education / snaptutorial.com

Data Center Market

Grocery App Development - Grocery Website Development | Start Online Grocery Business

Free Turnabout (Vino and Veritas) | PDF books

Download Trust Yourself: Stop Overthinking and Channel Your Emotions for Success at Work | PDF File

Download Influence, New and Expanded: The Psychology of Persuasion | PDF books

Download KS3 Spelling, Punctuation and Grammar All-in-One Complete Revision and Practice (Collins KS3 Revision) | PDF Fi

PDF The Future of Teaching: And the Myths That Hold It Back | PDF File

Google Professional-Data-Engineer權威考題 -最新Professional-Data-Engineer題庫資源

2023 L4M7 Braindump Pdf | Useful CIPS Whole Life Asset Management 100% Free New Question

Passing Customer-Data-Platform Exam Prep Materials - Customer-Data-Platform Valid Braindumps - VCE4Dumps

Real Databricks-Certified-Data-Engineer-Associate Testing Environment - How to Download for GAQM Databricks-Certified-Da

Data-Architecture-And-Management-Designer–100% Free Valid Dumps Pdf | Valid Salesforce Certified Data Architecture and M