I am generating a scorecard with the KPIs being scored from a scale of 1 – 5, 5 being the highest and 1 as the lowest. One of the KPIs is billable hours and I have a dataset from billable hours from last year and Q1 of this year. The mean of the data set is 60 and the standard deviation is 30. I can’t figure out what values to assign between 1 – 5 to ensure a normal distribution in a bell curve. Would appreciate if the excel formula is provided. I’m not very good in statistics and math but I can figure it out with an explanation and samples. Thanks!
You may also like
I faced an unusual problem on one of the live sites. The gift card module adds its “Gift Card by Amasty” option […]
Chicago, IL (PRWEB) April 15, 2013 Gorilla Group, an award-winning commerce service provider, has today announced that for the 3rd consecutive year […]
I write a ansible playbook for Kubernetes environment (timedata, swap, modules, containerd, kubeadm, kubelet, kubectl, vs). When I run the playbook, all […]
I can get widget parameters in the widget class like $this->getWidgetTitle() but here widget_title has been declared in widget parameters in widget.xml […]