Produce covariance and correlation matrix

Assignment Help Financial Accounting
Reference no: EM132656245

Pelican Stores Pelican Stores, a division of National Clothing, is a chain of women's apparel stores operating through out the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores. Data collected for a sample of 100 in-store credit card transactions at Pelican Stores during one day while the promotion was running are contained in the file named "PelicanStores". The proprietary Card method of payment refers to charges made using a National Clothing charge card. Customers who made a purchase using a discount coupon are referred to as promotional customers and customers who made a purchase but did not use a discount coupon are referred to as regular customers. Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make. Of course, Pelican also hopes that the promotional customers will continue to shop at its stores. In the data set, Items refers to the total number of items purchased and Net Sales refers to the total amount ($) charged to the credit card. Pelican's management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons. Managerial Report: Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign.

At the minimum, your report should include the following:

1. Percent frequency distribution for key variables.

2. A bar or pie chart showing the number of customer purchases attributable to the method of payment.

3. A cross tabulation of type of customer versus Gender. Make comments.

4. A scatter diagram to explore the relationship between net sales and customer age.

Question a: Produce covariance and correlation matrix to support the scatter diagram

Reference no: EM132656245

Questions Cloud

Calculate the balance on the firm bank statement at March : On 31 March the balance brought down on a firm's bank account in its ledger was £3,600, credit. Calculate the balance on the firm bank statement at March
Identify and compute the cost of the machine : Identify and compute the cost of the machine. Explain your reasoning. New parts to replace those damaged in unloading 2,000
Show the average variable cost function : Determine the level of production when the average variable cost (AVC) is minimum! (weight 10). Show the Average Variable Cost function
Key forces driving globalization : The Hofstede framework and its 5 main characteristics of culture - standard patterns of internationalization that a firm experiences
Produce covariance and correlation matrix : Produce covariance and correlation matrix to support the scatter diagram.A bar or pie chart showing the number of customer purchases attributable to the method
How should a lessee report operating lease payments : According to U.S. GAAP, how should a lessee report operating lease payments in the cash flow statement? Cash flow from operating and financing activities.
Prepare Diane statement of cash flows : Prepare Diane's statement of cash flows (in good form) for the year ended December 31, 2019. Diane uses the indirect method
Which company would have higher net income : Which company would have a higher research and development expense as a percentage of sales? Which company would have higher net income?
How do prepare a trial balance as of april : Post the journal entries from part 1 to the ledger accounts. The company made credit purchases for $17,400 in office equipment and $3,480 in office supplies.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Determine the company preliminary net income

Determine the company's preliminary net income. Earned $440 of service revenue; collected half in cash, with balance on credit.

  Determine the amount to withhold for federal income tax

Use the appropriate table to determine the amount to withhold for federal income tax from each of the following biweekly wages (biweekly withholding allowance = $153.80):

  What is the realized gross profit on installment sales

What is the realized gross profit on installment sales during the year? The balance being payable in equal monthly installments On July 1, 2016

  What amount should be shown for buildings on consolidate

Hanson had buildings with a book value of $1,878,000 and a fair value of $2,160,000. What amount should be shown for buildings on the consolidated balance sheet dated December 31, 2011? 106.

  What are the ethical issues in this case if any

What are the ethical issues in this case, if any? Would you have any concerns if you worked for the accounting department? Can the system be improved? If so, how?

  Distribution of cash upon liquidation

How should the money be distributed and assuming that the partnership has only $600 instead of $1,800, do any of the three partners have a capital deficiency? If so, how much?

  What are the six requirements of a valid contract

What famous U.S. Congressman resigned from Congress in 2005 after pleading guilty to taking $2.4 million in bribes - What would probably not be helpful in trying to ?nd and prosecute someone for accepting bribes and kickbacks?

  How should this losses be treated

maggie lost her job in the current year. She paid the expenses of owning aher home, interest on the mortgage, and property taxes out of savings. Her tax return shows negative taxable income of $20000. how should this loss be treated?

  How much of this loss may corbin deduct

Corbin has a $15,000 basis in his 50% ownership in an S corporation and lent the corporation $5,000 last year. The corporation has $30,000 of other debt. This year the corporation reported a $100,000 loss. How much of this loss may Corbin deduct?

  Profit and loss agreement

Partners A and B have a profit and loss agreement with the following provisions: salaries of $40,000 and $45,000 for A and B, respectively; a bonus to A of 10% of net income after salaries and bonus; and interest of 15% on average capital balances of..

  Prepare an income statement for subsidiary in stickles

Prepare an income statement for subsidiary in stickles and then translate these amounts to U.S. dollars - prepare a statement of retained earnings for this subsidiary in stickles and then translate these amounts into U.S. dollars.

  What is the analyst estimated value per share

The firm has $900 million of debt outstanding. If there are 900 million shares outstanding, what is the analyst's estimated value per share?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd