Help with Outliers and Standard Deviation on Excel
- or -
Post a project like this2976
$$
- Posted:
- Proposals: 4
- Remote
- #1046064
- Completed
Description
Experience Level: Intermediate
Description of excel work: The Gross Rate Column and Occ_SUM column are 2 columns that are updated manually with data. The Gross_Rate is the Gross Price charged and the Occ_SUM is the total number of rooms occupied at that given rate.
In the Std Dev Tab, i have 2 column one which is Average Rate and the other which is Standard Deviation, firstly i need this table in the FREQ tab to be set so that when data is entered the outliers are stripped this will be 5% of the average rate based on each period available. After that i would need the average rate tab to be automatically updated with the rate and the Stnd Dev tab with the standard deviation.
Ultimately I am looking to get rid of the numbers that are out of the norm and where the Occ Sum is not of great relevance. This will feed through to my FULL_DP tab which will automatically update in to it's formulated row.
So just to make it clear, as and when new data is entered in to the the FREQ table i would need the outliers to remove themselves automatically or at-least i would like to be shown how to remove them if i have to do it. I will need the average rate to be updated by period automatically in the Std Dev tab and also the Standard Deviation to be automatically updated in the table under the Std Dev Tab.
Extra notes:
In the Std Dev Tab, i have 2 column one which is Average Rate and the other which is Standard Deviation, firstly i need this table in the FREQ tab to be set so that when data is entered the outliers are stripped this will be 5% of the average rate based on each period available. After that i would need the average rate tab to be automatically updated with the rate and the Stnd Dev tab with the standard deviation.
Ultimately I am looking to get rid of the numbers that are out of the norm and where the Occ Sum is not of great relevance. This will feed through to my FULL_DP tab which will automatically update in to it's formulated row.
So just to make it clear, as and when new data is entered in to the the FREQ table i would need the outliers to remove themselves automatically or at-least i would like to be shown how to remove them if i have to do it. I will need the average rate to be updated by period automatically in the Std Dev tab and also the Standard Deviation to be automatically updated in the table under the Std Dev Tab.
Extra notes:
Saqib A.
100% (62)Projects Completed
48
Freelancers worked with
46
Projects awarded
50%
Last project
16 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies