Question: please answer with excel formulas tore owner is interested in opening a second shop. She wants to estimate the true average daily revenue of her

please answer with excel formulas

tore owner is interested in opening a second shop. She wants to estimate the true average daily revenue of her current shop to decide whether expanding her business is a good idea. The store owner takes a random sample of 60 days over a six-month period and finds that the mean revenue of those days is 3,472.00 dollars with variance 315,900.20 square dollars. Calculate a 95% confidence interval to estimate the true average daily revenue. HOME INSERT DATA fx $3,472.00 1 Mean 2 Variance$315,800.20 4 Lower 5 Upper

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Decision Support Tools Main Content Quiz Test 2 (S1) Question 1 Answer saved Marked out of 1.00 Question text If we know that the length of time it takes a college student to find a parking spot in...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

I have 6 assignment about accounting capstone class. Its just and one project but its 6 assignment. Here is the document Assignment 1 It might be difficult for you to imagine yourself in a...

During the depression of the 1930s, Ben Jenkins, Sr., a wealthy, expansion-oriented lumberman whose family had been in the lumber business in the southeaster United States for several generations,...

Basis below case , kindly answer ; Question to be Answered : What will be the best exit option for Nigel and Tammy if they decide to do so? Should We Stay or Should We Go? The Case of the Adventure...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Consider the different responsibilities involved in the following three positions at Vortnoy Corporation: (1) supervisor of the second shift at the Fairfield, Rhode Island, plant, (2) manager for the...

Consider the following: a. The bakery department of a Publix supermarket reports income for the current year. b. Pace Foods is a subsidiary of Campbell Soup Company. c. The personnel department of...

The writer of a put option is obligated to provide the specified financial instrument at the price specified by the option contract if the owner exercises the option. Group of answer choices True...

I've already completed the calculations; however, I need help with the "check all that apply" question. Ch 06: Assignment - Accounting for Financial Management negative cor sell recommendation in the...

(Appendices) PURCHASES RECORDED GROSS. Dawson Enterprises uses the periodic system and records purchases gross. On a recent day, Dawson engaged in the following three transactions: LO2 a) Purchased...

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: CREDIT SALES METHOD. Bradford ~Plumbing had the following data for a recent year. LO8 REQUIRED: 1. Compute uncollectible account expense for the year. 2....

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: AGING METHOD. Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year: LO6