ACS 401 Assignment One Guytano Virdo, PhD 18/02/2023 DUE DATE: March 10th by 5 pmAssignment Guidelines1) Access your dataset and change the formatting as you have been instructed in labs. ...

Let me know if this excel project can be done


ACS 401 Assignment One Guytano Virdo, PhD 18/02/2023 DUE DATE: March 10th by 5 pm Assignment Guidelines 1) Access your dataset and change the formatting as you have been instructed in labs. This includes making the headings stand out and ensuring adequate spacing for each cell. The dataset is the file with the last four digits of your student number as the file name. Using the wrong dataset will result in a failing grade. (10 points) 2) Calculate all appropriate descriptive statistics (measures of central tendency and dispersion) for the operating budget and number of employees variables. These statistics should be labelled and calculated clearly in your excel file. Your document should contain two paragraphs (one for each variable) summarizing the results. (30 points) 3) Create an appropriate graph (pie graph, bar graph, or histogram) for the sector, operating budget, number of employees, and customer loyalty variables. The following criteria must be met. - Histograms must have 10 bins - The number of organizations from each sector must be shown - The number of organizations with each level of customer loyalty must be shown Copy and paste your graph to your word document. For each graph, state the variable’s level of measurement and describe the distribution in a few sentences. (30 points) 4) Create a new variable (to the right of the number of employees column) equal to the percentage of each organization’s percent of the total number of employees for the sample in excel. Give this variable the name % of total employees. Create a boxplot (aka box and whisker plot). Copy this boxplot to your .doc and interpret it in a paragraph. (30 points) BONUS (worth 1 percent): Each of the organizations is a reference to a real-world organization. Any student that correctly identifies all of them gets a 1% bonus. Simply add a new column with the corresponding real-world organization in the same row as the fake one. Formatting and submission guidelines: - Submit your assignment through the course D2L, including: o Your final excel file o Your written work in a .doc or .pdf file - Your written work should formatted in: o 12 pt font o 1-inch margins o Any reasonable font choice (though Garamond is objectively the best font) Sheet1 OrganizationSectorOperating budgetNumber of employeesCustomer loyalty Possible BurgerFood62106204High Gop IncRetail5046065Medium Republic of BananaRetail329197Low TokTikIT8543772High BookFaceIT13874204Low McRonaldsFood11237206High WallmortRetail60364149High CIBDFinancial703794High InstashamIT35589239Low American FreagleRetail52534183Medium ShopicryIT8077146Medium PopguysFood9051155High Four Guys Burger N FriesFood86056122High LuLuLimeRetail41157122Medium Burger QueenFood13926131Low FauxritziaRetail76979159Low Jim HortonsFood2728551Medium Michael NorsRetail63971107High DT BankFinancial77542114High Scoia'tel BankFinancial22341167High Sushi-UFood5453964Medium Over ArmourRetail52316186High XaraRetail69964191High Sneaky BeesFood2971679High