PLEASE HELP WITH THE PIVOT TABLE QUESTIONS AND SHOW EXCEL STEPS USED IN THE PROCESS. ***NOTE: PIVOT TABLE WILL BE POSTED IN SEPARATE QUESTION****
Saeko has a yarn shop and wants to expand the colors in her yarn lines. She sends you the raw data in the Pivot Table Data below.
This data consists of the number of yards and meters of the color names, and the color types that each name belongs to, sold during her busiest weekend last year. Use the Pivot Table Data to create a pivot table that shows Saeko the number of yards and meters that were sold in the various yarn types during the busiest weekend of her shop last year.
As the data was not in excel format, it was difficult to paste it in excel. So I have taken the first 30 rows as sample data. Based on the sample data, I will try to solve the problem and you can replicate the same steps to solve the problems on the entire data set.
Steps to create Pivot from the excel data.
1. Select the columns and rows on which you want to create the pivot table.
2. Click on Insert - Pivot Table
3. It will by default show the selected table range and the pivot table to be created on new work sheet.
4. Click on Ok.
5. In the pivot table fields, drag color type into rows and yards, meters into values as shown below. Select sum of yards and meters.
7. The following Pivot table shows the number of yards and meters sold for various colour types from the sample data.
B. the min() function should be used as shown below to find the color type which sold least
It returns the value of 762 which corresponds to Yellow color type.
Maximum color sold can be found by using max() function below.
Max yards sold is 3515 which belongs to Green color.
So the least selling color is yellow and maximum selling color is Green.
If Seiko wants to invest in least and max selling colors, then he should invest in Yellow and Green.
Please note the above solution was based on sample data using first 30 rows. You should follow the same steps to arrive at solution for the entire data set.
Hope it helps.if you have any query just ask me how.i am here to helps you. dont give you direct thums down.if you satishfied to my work please give me vote for THUMS UP. THANK YOU SO MUCH
PLEASE HELP WITH THE PIVOT TABLE QUESTIONS AND SHOW EXCEL STEPS USED IN THE PROCESS. ***NOTE:...
PLEASE HELP WITH THE PIVOT TABLE QUESTIONS AND SHOW EXCEL STEPS USED IN THE PROCESS. ***NOTE: PIVOT TABLE WILL BE POSTED IN SEPARATE QUESTION**** Saeko has a yarn shop and wants to expand the colors in her yarn lines. She sends you the raw data in the Pivot Table Data below. This data consists of the number of yards and meters of the color names, and the color types that each name belongs to, sold during her busiest weekend last...
Use the table below to answer the following question(s). Remington Textiles has a mill that produces three types of fabrics on a make-to-order basis. The mill operates on a 24/7 basis. The key decision facing the plant manager is about the type of loom needed to process each fabric during the coming 12 weeks to meet demands for the three fabrics and not exceed the capacity of the looms in the mill. Two types of looms are used: Jaquard and...
Help me answer each question STEP by STEP (can use excel, if so show me the formulas please!) According to a retail organization, holiday shoppers spent an average of $935.58 over the Thanksgiving weekend in 2016. The accompanying data show the amount spent by a random sample of holiday shoppers during the same weekend in 2017. Complete parts a through c. Click here to view the shopping data. Click here to view the t-distribution table data. a. Test the hypothesis...
QUESTION 80 Use the table below to answer the following question(s). Remington Textiles has a mill that produces three types of fabrics on a make-to-order basis. The mill operates on a 24/7 basis. The key decision facing the plant manager is about the type of loom needed to process each fabric during the coming 12 weeks to meet demands for the three fabrics and not exceed the capacity of the looms in the mill. Two types of looms are used:...
I need help with this java project and please follow the instruction below. thank Class Project - Parking Ticket simulator Design a set of classes that work together to simulate a police officer issuing a parking ticket. Design the following classes: • The ParkedCar Class: This class should simulate a parked car. The class’s responsibilities are as follows: – To know the car’s make, model, color, license number, and the number of minutes that the car has been parked. • ...
Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field. After you have completed the import, open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change...
Please show the steps clearly 1. A company is involved in the production of two items (X and Y). The resources need to produce X and Y are twofold, namely machine time for automatic processing and craftsman time for hand finishing. The table below gives the number of minutes required for each item: Table 1: Minutes required for each item Item Machine time Crafstman time Item X 13 20 Item Y 19 29 The company has 40 hours of machine...
Please help use this credit card table to answer the following questions. directions Use the credit card statement below to answer these questions: 1. What is the date of the statement? 2. What is the Annual Percentage Rate (APR)? 3. What is the corresponding periodic rate? 4. What is the new balance? 5. What was the previous balance? 6. How many charges were made during the billing cycle? 7. How many credits and payments were made during the billing cycle?...
Please put in excel data table with rows and columns and please provide both answer and formula. Thank you. 84 Learning Urat 16- Gross profit from sales. Net income. Quiz e. LU 16-2 PRSTICE Or d. a. Net sales b. Cost of merchandise (goods) sold Given: Gross sales, $35,000, sales returns and allowances s Quls to From the following information, calculate to Compiate this Practice see how you are doing $6,000, net purchases, $7,000,ending inventory, 5,500opratinning Solutions Sales returns and...
484 Core Concepts of Accounting Information Systems a. Using Access, create an employee table sim- ilar to the one shown in Figure 15-4. Create created. (Hint You can use the aforemen- tioned expression for the department code as a validation rule.) at least one record for this table b. Create validation rules for the listed restric tions and an accompanying validation text for each. Document your work by provid- ing a table outlining exactly what rules you c. Test each...