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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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