Purchase Solution

Eddie Bauer: Points and using Excel

Not what you're looking for?

Ask Custom Question

A clothing retailer gives you 10 points for every $1 spent, and you can trade in 2,550 points for a $15 gift certificate.

a.) The spreadsheet lists purchases and their prices. Create formulas which compute the cost of each item and the points you get from each item.
b.) Compute the total cost of the order and the total number of points from the order.
c.) Compute how many $15 gift certificates you will get from this order and the total value of these gift certificates. Note: you cannot get a fractional gift certificate so use the INT function which gives the integer part of a number (effectively it rounds down). Format with zero decimal places.
d.) What is the ratio of money spent to the value of the gift certificates? Enter a formula in cell I21 for this ratio with the second quantity scaled to one.

Purchase this Solution

Solution Summary

All formulas, computations, and solutions are contained in the Excel file.

Solution provided by:
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution


Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Probability Quiz

Some questions on probability

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.