# Statistics-AW-Q149

## Statistics-AW-Q149 Online Services

Problem 1 (25 Points)

In the sheet “Problem 1” you are given a list of festivals, their locations and the seasons that they fall in.

1. Using IF, filter the data for these festivals by season. You will need to add a column for each season and then use the IF function to filter the data by season. Your formula should use proper anchoring so it is copyable both down and across.
2. Calculate the total number of festivals each season as well as the percentage of festivals that fall in each season. Use ROUND to round the percentage to the nearest whole number.Compu

Your solution must look like this (including the formatting)

Your solution must take into account the possibility that the data could change, i.e., do not “hard code” any data values. If the season of a festival changes, your calculations should update to the correct values automatically. Additionally, if new rows are inserted or existing rows are deleted, your spreadsheet model should still work.

Problem 2 (50 Points)

In the sheet “Problem 2”, you are given information about a savings account. Use this information to create a savings calculator. Notice that some cells have been given names. Use these names in formulas where appropriate. You can view all named cells in the Name Manager under the Formulas tab.

1. Use formulas to fill in the columns as shown below, including the column for DepNo. Lookup the DATE and/or EDATE functions to figure out how to fill in the Deposit Date column. You should type in the Extra Deposits as they appear in the figure below since you cannot figure them out with a formula.

2. In cell I7, calculate the total amount of scheduled deposits.
3. In cell I8, calculate the total amount of extra deposits.
4. In cell I9, calculate the total amount of interest earned.
5. In cell I10, calculate the percentage that the account has increased by.
6. In cell I11, use an IF statement to determine whether the goal has been reached at the end of the savings period.
7. Use conditional formatting to shade cell I11 green if the goal has been reached and red if it has not been reached.

Here is what your solution should look like

You can read more about our case study assignment help services here.

## How it Works

#### How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

## Case Approach

#### Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

## Related Services

Make sure that your

● formulas are “copyable”, i.e., that they use absolute references (\$) wherever needed
● IF statements do not hard code amounts, but rather use cell references
● the cells are formatted as shown in the solution above

Problem 3 (25 Points)

In the sheet “Problem 3” you are to create various loan payment scenarios. The loan has an initial balance (cell C1) of \$50,000.

1. Create a column of years from 0 through 20 of the life of the loan. Use a formula starting in Year 1.
2. Create columns for 5 different interest rates: 2%, 4%, 6%, 8% and 10%.
3. Use the PMT function to calculate the monthly payment due if the loan is paid in full at the end of each period. For instance, the monthly payment of a loan with a 2% interest rate that is to be paid in 5 years would be \$876.39. Make sure that your formulas use proper anchoring (\$) to allow the formulas to be copied. You should be able to copy the formula down and across without changing the formula.

4. Format the model exactly as shown.
5. Test your model with different initial balances and interest rates.