The database dish.xlsx contains a transaction history

Assignment Help Database Management System

Reference no: EM13511587

The database Dish.xlsx contains a transaction history describing more than 4,000 purchases of detergent
at a number of stores in a grocery chain over a period of several weeks.
a) How many records are in this database?
b) How many fields are in this database?
c) Is the field SALE nominal or numerical?
d) Is the variable PRICE measured on an interval or ratio scale?
e) Which field contains blank cells, and how may does it contain?
f) What is the highest price in the database?
1g) How many records pertain to the description SUNLIGHT GEL 2.49?
h) Create a histogram of the PRICE variable and interpret it.
i) What is the average price?
j) Are higher priced products generally more profitable?
k) Does profit vary systematically across stores?
l) In week 387, which stores had average profit over 18?

Reference no: EM13511587

Questions Cloud

Evaluate the wavelength of line a : The emission spectrum for a one-electron ion in the gas phase. All the lines result from electronic transitions from excited states to the n=3 state. If the wavelength of line B is 142.5 nm, calculate the wavelength of line A.

Example of something that one culture might : Give an example of something that one culture might regard as a virtue that another culture might not. Explain why this could lead to relativism.

Discuss and compare sterlings scientific approach : Discuss and compare Sterlings scientific approach to standard setting with the judicial or jurisprudential approach of Stamp.

Determine the speed of flow in the upper section : Water moves through a constricted pipe in steady, ideal flow. At the lower point shown in the figure below, the pressure is P1 = 2.00 104 Pa, Find the speed of flow in the upper section

The database dish.xlsx contains a transaction history : The database Dish.xlsx contains a transaction history describing more than 4,000 purchases of detergent

Explain alcohol ethyl alcohol/ethanol content in a bottle : The alcohol (ethyl alcohol/ethanol) content in a bottle of beer is about 5%. The man's weight is 150 lbs and he was drinking over an hour period. State the chemical reaction that took place in the patient's body.

What is individualism-influence of social structure : Why is cicrocredit so important and why? Why does the Grameen Bank focus primarily on women as lendees? What is individualism? How is the influence of social structure demonstrated in the study of unemployment and family homelessness as public issues..

Explain starch and sucrose and glyceryl tristearate : State the products formed when each of the following are hydrolyzed: starch, sucrose, glyceryl tristearate, and the general products of protein.

What npv is calculated using this method : The Happy Pappy Puppy Company has compiled the following data for adding a new line of pets to their stores.

User Account

All Pages