T Seem Figure Correct Commands M Using Jupyter Notebook Vector Numbers 1 2 3 4 5 Square Q43855302

I can’t seem to figure out the correct commands for this (I’musing jupyter notebook)

You have a vector of numbers A = [1 2 3 4 5].

i. How can you square each element of this vector? In otherwords, create a vector B that is [1^2 2^2 3^2 4^2 5^2 ].

ii. Now create a variable C that represents the third value in B(your variable should specifically refer to “the third index of thevector B”, rather than you inputting its numerical value).

Expert Answer

Answer to I can’t seem to figure out the correct commands for this (I’m using jupyter notebook) You have a vector of numbers A = […

T Seem Figure Mistake Please Help Don T Know Error Means Either Don T Know Change Make Pr Q43880241

I can’t seem to figure outwhat the mistake is. Please help. I don’t know what the error meanseither and I don’t know what to change to make the program run.

Instructions DebugOne4.cs >_ Terminal 1 using static System.Console; 3 class DebugOne4 The provided file has syntax and/or logical errors. Determine the problem and fix the program. 5 static void Main() DebugOne4.cs(13,22): error CS0117: System.Console’ do es not contain a definition for ‘Writeline’ /usr/lib/mono/4.5/mscorlib. dll (Location of the symbol related to previous error) Compilation failed: 1 error (s), o warnings Cannot open assembly ‘Debug One4.exe’: No such file or directory. Grading When you have completed your program, click the Submit button to record your score. 7 System.Console.WriteLine(“How to play tic tac toe:”); 8 System.Console.WriteLine(“Draw a three by three grid.”); 9 System.Console.WriteLine(“The first player puts an X in any of the nine locations.”); 10 System.Console.WriteLine(“The second player puts an o in any remaining location.”); 11 System.Console.WriteLine(“Players alternate turns until one has three of the same symbol in a row”); 12 System.Console.WriteLine(“vertically, horizontally, or diagonally.”); 13 System.Console.Writeline(“If all nine squares are filled without three in a row,”); 14 System.Console.WriteLine(“the game ends in a tie.”); 15 ] म Show transcribed image text Instructions DebugOne4.cs >_ Terminal 1 using static System.Console; 3 class DebugOne4 The provided file has syntax and/or logical errors. Determine the problem and fix the program. 5 static void Main() DebugOne4.cs(13,22): error CS0117: System.Console’ do es not contain a definition for ‘Writeline’ /usr/lib/mono/4.5/mscorlib. dll (Location of the symbol related to previous error) Compilation failed: 1 error (s), o warnings Cannot open assembly ‘Debug One4.exe’: No such file or directory. Grading When you have completed your program, click the Submit button to record your score. 7 System.Console.WriteLine(“How to play tic tac toe:”); 8 System.Console.WriteLine(“Draw a three by three grid.”); 9 System.Console.WriteLine(“The first player puts an X in any of the nine locations.”); 10 System.Console.WriteLine(“The second player puts an o in any remaining location.”); 11 System.Console.WriteLine(“Players alternate turns until one has three of the same symbol in a row”); 12 System.Console.WriteLine(“vertically, horizontally, or diagonally.”); 13 System.Console.Writeline(“If all nine squares are filled without three in a row,”); 14 System.Console.WriteLine(“the game ends in a tie.”); 15 ] म

Expert Answer

Answer to I can’t seem to figure out what the mistake is. Please help. I don’t know what the error means either and I don’t know w…

T1 Q7 Assume Following 2 Transactions Run Concurrently Could Find Conflict Occurring Yes T Q43786792

T1 Q7: Assume you have the following 2 transactions that will run concurrently. Could you find a conflict occurring between them? If yes, try to avoid it using 2PL. T2 read-item (X); read-item (X); read-item (Y); read-item (2); Y:= Y + X; Z:= Z+X; write-item (Y); read_item (Y); Y:=Y+X; write-item (Z); write-item (Y); Show transcribed image text T1 Q7: Assume you have the following 2 transactions that will run concurrently. Could you find a conflict occurring between them? If yes, try to avoid it using 2PL. T2 read-item (X); read-item (X); read-item (Y); read-item (2); Y:= Y + X; Z:= Z+X; write-item (Y); read_item (Y); Y:=Y+X; write-item (Z); write-item (Y);

Expert Answer

Answer to T1 Q7: Assume you have the following 2 transactions that will run concurrently. Could you find a conflict occurring betw…

T1 T2 T3 R X R Y R Z R X W X Using Dependency Graph Determine Whether Schedule Conflict Se Q43798571

T1 T2 T3 R(X) R(Y) R(Z) R(X) W(X) By using a dependency graph determine whether this schedule is conflict serializable. If it is conflict serializable, what is the equivalent serial schedule? R(Y) W(Z) Show transcribed image text T1 T2 T3 R(X) R(Y) R(Z) R(X) W(X) By using a dependency graph determine whether this schedule is conflict serializable. If it is conflict serializable, what is the equivalent serial schedule? R(Y) W(Z)

Expert Answer

Answer to T1 T2 T3 R(X) R(Y) R(Z) R(X) W(X) By using a dependency graph determine whether this schedule is conflict serializable. …

Table Name Director Dirnum Dirlname Dirdob 100 Broadway 12 Jan 65 101 Hollywoody 18 Nov 53 Q43857810

Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Part 3: Keys and the Index Using the model to the right, identify the following (write None if not applicable): DIR_NUM Table name: PLAY PLAY_CODE P LAY_NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice 102 100 Enter answer here: Question Primary key in the DIRECTOR table: Foreign key in the DIRECTOR table: Primary key in the PLAY table: Foreign key in the PLAY table: Cardinality of the relationship between DIRECTOR and PLAY: Suppose you wanted a quick lookup capability to get a listing of all plays directed by a given director. Identify the table that would be the basis of the INDEX table: and what would be the index key: Fill in the table below that depict the contents of the conceptual INDEX table. Index Key Pointers Show transcribed image text Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Part 3: Keys and the Index Using the model to the right, identify the following (write None if not applicable): DIR_NUM Table name: PLAY PLAY_CODE P LAY_NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 1006 Starstruck in Biloxi 1007 Stranger In Parrot Ice 102 100 Enter answer here: Question Primary key in the DIRECTOR table: Foreign key in the DIRECTOR table: Primary key in the PLAY table: Foreign key in the PLAY table: Cardinality of the relationship between DIRECTOR and PLAY: Suppose you wanted a quick lookup capability to get a listing of all plays directed by a given director. Identify the table that would be the basis of the INDEX table: and what would be the index key: Fill in the table below that depict the contents of the conceptual INDEX table. Index Key Pointers

Expert Answer

Answer to Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy 21-Jun-62 Part …

Table Playtennis Decision Based Four Attributes Given Assume Humidity Chosen Root Node 15 Q43823399

A table of “PlayTennis” decision based on four attributes is given below. Assume that “Humidity” is chosen at the root node. (a) (15 points] What is the information gain of using “Wind” at the branch “Humidity” =High? (b) (10 points) Draw a sample decision tree without doing any optimization, but obtaining “pure” leaves at the end. Temperature Play Tennis Hot Humidity Outlook Sunny Sunny Overcast Rain Rain High Rain Overcast Humidity High High High High Normal Normal Normal High Normal Normal Normal High Normal High Wind Weak Strong Weak Weak Weak Strong Strong Weak Weak Weak Strong Strong Weak Strong Wind Hot Hot Mild Cool Cool Cool Mild Cool Mild Mild Mild Hot Mild Wind Sunny Sunny Rain Sunny Overcast Overcast D14 || Rain Show transcribed image text A table of “PlayTennis” decision based on four attributes is given below. Assume that “Humidity” is chosen at the root node. (a) (15 points] What is the information gain of using “Wind” at the branch “Humidity” =High? (b) (10 points) Draw a sample decision tree without doing any optimization, but obtaining “pure” leaves at the end. Temperature Play Tennis Hot Humidity Outlook Sunny Sunny Overcast Rain Rain High Rain Overcast Humidity High High High High Normal Normal Normal High Normal Normal Normal High Normal High Wind Weak Strong Weak Weak Weak Strong Strong Weak Weak Weak Strong Strong Weak Strong Wind Hot Hot Mild Cool Cool Cool Mild Cool Mild Mild Mild Hot Mild Wind Sunny Sunny Rain Sunny Overcast Overcast D14 || Rain

Expert Answer

Answer to A table of “PlayTennis” decision based on four attributes is given below. Assume that “Humidity” is chosen at the ro…

Table Playtennis Decision Based Four Attributes Given Assume Humidity Chosen Root Node 15 Q43823405

A table of “PlayTennis” decision based on four attributes is given below. Assume that “Humidity” is chosen at the root node. (a) (15 points] What is the information gain of using “Wind” at the branch “Humidity” =High? (b) (10 points) Draw a sample decision tree without doing any optimization, but obtaining “pure” leaves at the end. Temperature Play Tennis Hot Humidity Outlook Sunny Sunny Overcast Rain Rain High Rain Overcast Humidity High High High High Normal Normal Normal High Normal Normal Normal High Normal High Wind Weak Strong Weak Weak Weak Strong Strong Weak Weak Weak Strong Strong Weak Strong Wind Hot Hot Mild Cool Cool Cool Mild Cool Mild Mild Mild Hot Mild Wind Sunny Sunny Rain Sunny Overcast Overcast D14 || Rain Show transcribed image text A table of “PlayTennis” decision based on four attributes is given below. Assume that “Humidity” is chosen at the root node. (a) (15 points] What is the information gain of using “Wind” at the branch “Humidity” =High? (b) (10 points) Draw a sample decision tree without doing any optimization, but obtaining “pure” leaves at the end. Temperature Play Tennis Hot Humidity Outlook Sunny Sunny Overcast Rain Rain High Rain Overcast Humidity High High High High Normal Normal Normal High Normal Normal Normal High Normal High Wind Weak Strong Weak Weak Weak Strong Strong Weak Weak Weak Strong Strong Weak Strong Wind Hot Hot Mild Cool Cool Cool Mild Cool Mild Mild Mild Hot Mild Wind Sunny Sunny Rain Sunny Overcast Overcast D14 || Rain

Expert Answer

Answer to A table of “PlayTennis” decision based on four attributes is given below. Assume that “Humidity” is chosen at the ro…

Table Shows Value Predicate Mix Y Every Possible Combination Values Variables X Y Domain X Q43908211

Do e

Do c, e, g

Do b

The table below shows the value of a predicate Mix,y) for every possible combination of values of the variables x and y. The domain for x and yis (1.2.3). The row number indicates the value for x and the column number indicates the value for y. For example M{1, 2) = Fbecause the value in row 1 column 2 is F. Indicate whether each of the logical expressions is a proposition. If so, indicate whether the proposition is true or false (a) M(1.1) Solution Proposition True vy MIX) (c) ax MIX 3) Solution Pico True Tot 10x_2 Mix, 3) s true x y Mix ” vy Mix) W Solution Not a proposition. The variablexis not bound Determine the truth value of each expression below. The domain is the set of all real numbers. (a) vxay (xy > 0) Solution False. If x = 0, there is no y such that xy > 0. b) 3xvy (xy=0) Solution True. If x 0, then for all y, xy = 0. vxwy3z (z = (x – y)/3) vxayvz (z-(- y)/3) | vyvy (X) = y) (1) axayaz (x + y = z) Solution True. One example is x = 3, y = 4, z = 5 ” Tayyi x way (x sovy= x) The domain for variables x and y is a group of people. The predicate F(x, y) is true if and only if x is a friend of y. For the purposes of this problem, assume that for any person x and person y, either x is a friend of y or x is an enemy of y. Therefore, -F(x,y) means that x is an enemy of y Translate each statement into a logical expression. Then negate the expression by adding a negation operation to the beginning of the expression. Apply De Morgan’s law until the negation operation applies directly to the predicate and then translate the logical expression back into English (a) Everyone is a friend of everyone. Solution • vx wy F(x, y) • Negation VX vy F(x, y) • Apply De Morgan’s law ax ay -F(xy) • English Someone is an enemy of someone Someone is a friend of someone Someone is a friend of everyone. Everyone is a friend of someone. Show transcribed image text The table below shows the value of a predicate Mix,y) for every possible combination of values of the variables x and y. The domain for x and yis (1.2.3). The row number indicates the value for x and the column number indicates the value for y. For example M{1, 2) = Fbecause the value in row 1 column 2 is F. Indicate whether each of the logical expressions is a proposition. If so, indicate whether the proposition is true or false (a) M(1.1) Solution Proposition True vy MIX) (c) ax MIX 3) Solution Pico True Tot 10x_2 Mix, 3) s true x y Mix ” vy Mix) W Solution Not a proposition. The variablexis not bound
Determine the truth value of each expression below. The domain is the set of all real numbers. (a) vxay (xy > 0) Solution False. If x = 0, there is no y such that xy > 0. b) 3xvy (xy=0) Solution True. If x 0, then for all y, xy = 0. vxwy3z (z = (x – y)/3) vxayvz (z-(- y)/3) | vyvy (X) = y) (1) axayaz (x + y = z) Solution True. One example is x = 3, y = 4, z = 5 ” Tayyi x way (x sovy= x)
The domain for variables x and y is a group of people. The predicate F(x, y) is true if and only if x is a friend of y. For the purposes of this problem, assume that for any person x and person y, either x is a friend of y or x is an enemy of y. Therefore, -F(x,y) means that x is an enemy of y Translate each statement into a logical expression. Then negate the expression by adding a negation operation to the beginning of the expression. Apply De Morgan’s law until the negation operation applies directly to the predicate and then translate the logical expression back into English (a) Everyone is a friend of everyone. Solution • vx wy F(x, y) • Negation VX vy F(x, y) • Apply De Morgan’s law ax ay -F(xy) • English Someone is an enemy of someone Someone is a friend of someone Someone is a friend of everyone. Everyone is a friend of someone.

Expert Answer

Answer to Do e Do c, e, g Do b…

Table Tools Celchosml2fiesta Collection Instructions Saved References Mailings Review View Q43806341

Table Tools cel_CHOS_ML2_Fiesta Collection Instructions – Saved References Mailings Review View Help Design Layout Search Points Possible Step Instructions Start Excel. Download and open the file narned Exp19_Excel Cho5_ML2_Fiesta.xlsx. Grader has automatically added your last name to the beginning of the filename. The workbook contains two related tables. You must create a relationship between these tables so that you can create a Pivot Table using data from both tables Create a relationship between the items table using the Color Number field and the Colors table using the Color Number field. Now that the relationship is built, you are ready to create a Pivottable. Create a blank Pivot Table from within the Items table on the Collection worksheet to analyze multiple tables. Add the data to the data model. Place the Pivo Table on a new worksheet and name the worksheet Retired Colors. Name the Pivot Table Retired. Display the names of both tables in the PivotTable Fields task pane. Display the Color field as rows and the sum of the Replacement Value field as values Retired colors are often worth more than currently available colors. Therefore, you want to filter the data to show only retired colors Add a filter to display aggregates for retired colors only using the Retired field. Note that current colors do not have a retirement date, so you must filter out the blanks Apply the Light Green, Pivot Style Medium 7. Note, depending on the version of Office used, the style name may be Pivot Style Medium 7. In the Retired Colors sheet, format the values with Accounting Number Format with two decimal places In cell B3, create a custom heading named Replacement Values. Change Row Labels in cell A3 to Retired Colors 9 You want to add a second value field to display values as percentages of the grant total. Add a second Replacement Value field below the current field in the values area Select the option to display the values as percentages of the grand total Type the custom name Percent of Total 10 Add a slicer for the Color field Select these colors to dislav Anrient Chartreuse llac References 10 Mailings Review View Help Design Layout Search Add a slicer for the Color field. Select these colors to display Apricot Chartreuse, Lilac Marigold Pearl Grey, and Sapphire. Created On: 05222019 bip19 L el ChOS ML2 – Fiesta Collection 10 Grader – Instruction Excel 2019 Prod Step Points Instructions Possible You want to customize the slicer Apply the Light Green, Slicer Style Light 6 style Note depending on the version of Office used, the style name may be Slicer Style Light 6 Display three columns within the sicer window Change the button width to 1.5 inches. Move the slicer so that the top left corner starts in cell E2 A PivotChart will create a visual illustration of the data in the Pivot Table Create a clustered column PivotChart and place it on a new chart sheet named Retired PivotChart Now that the PivotChart is created, you are ready to format it Change the chart title to Replacement Value of Retired Items Change the data point il color to Purple Change the value as font size to 11 and apply Black Text 1 font color Change the category as font size to 11 and apply Black Text 1 font color. Hide the field buttons on the PivotChart. JO e a wg Table Tools 19_Excel Cho5_ML2 Fiesta_Collection Instructions. Saved References Mailings Review View Help Design Layout Search Grader-Instructions Excel 2019 Project Step Instructions Points Possible You want to customize the slicer Apply the Light Green Slicer Style Light 6 style Note depending on the version of Office used, the style name may be Slicer Style Light 6. Display three columns within the slicer window. Change the button width to 1.5 inches. Move the slicer so that the top-left corner starts in cell E2 A PivotChart will create a visual illustration of the data in the PivotTable Create a clustered column PivotChart and place it on a new chart sheet named Retired PivotChart Now that the PivotChart is created, you are ready to format it Change the chart title to Replacement Value of Retired Items Change the Lilac data point fill color to Purple Change the value as font size to 11 and apply Black Text 1 font color Change the category axis font size to 11 and apply Black, Text 1 font color. Hide the field buttons on the PivotChart. On all sheets, create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side Ensure the worksheets are in the following order Color List, Retired PivotChart Retired Colors Collection 17 Save and close Exp19_Excel_CHO_ML2_Fiestaxlsx Exit Excel Submit the file as directed DOBê e a wg File Insert Draw Page Layout Formulas Data Review View Help Time what you want to do Share PC Home Хаа Псору – 20 P etere to watch LOWO File Home Insert Draw Data Review Page Layout 11 O Formulas AA . A Caliburi BIV View Help Design Wrap Text Center – $ .% EE Entus- Copy from Tell me what you want to do EE . Condtional Format as Cell Formatting table Styles Styles Insert Delete Format inter Chyboard X Color Number Color Numm um 830 er Spiece Place Setting Covered Casserole Pitcher Large Disc eray Set 104 S 104 Replacement Value 6.95 Keith’s Antique Store A la Replac e d Thayetion O by Auction 24 thay Action 21.99 Replacements, the 1999 by Auction 15. Replacements, 7.99 Downtown Antique Store 41.99 Replacements, 19. Replacements, Lid 1.9 The Home Laughlin China Co. 32. The Home Layhin China Co. 2.99 The Home Lwin China Coc 25.99 The Home in China Co. 21.28 bay Auction 19.09 The Home Cina Coc 159 The Home Cina C 15 The Home Cinco Salt and pepper Set Bowl Large 1 Individual Creamer Luncheon Plate Carate Covered Coffee Server Sugar Cream Tray Set Patcher Large Disc 5 Pece Plate Setting 101 AD Cup and Saucer Chop Plate Oy Salt and pepper Set 101 101 Soon Rest 12 The Chica 10 The 101 6 The Home Cina C Piece Pace Setting Collection Color List Type here to search o e o Project Description: Your Aunt Laura has been collecting Fiesta dinnerware, a popular brand from the Homer Laughlin China Company, since 1986. You help her maintain an inventory So far, you and Aunt Laura have created a table of color numbers, color names year introduced, and year retired, if applicable. In a second table, you entered color numbers, item numbers, items, current value, and source. Previously, you helped her research current replacement costs, however, you believe the retired colors may be worth more now. Laura is especially interested in the values of retired colors so that she can provide this information for her insurance agent. You will build a Pivot Table and add slicers to help her with the analysis Steps to Perform: Step Instructions Points Possible Start Excel Download and open the file named Exp19 Excel Ch05 ML2 Fiesta xlsx Grader has automatically added your last name to the beginning of the filename. The workbook contains two related tables. You must create a relationship between these tables so that you can create a Pivot Table using data from both tables Create a relationship between the items table using the Color Number field and the Colors table using the Color Number field. Now that the relationship is built, you are ready to create a Pivot Table Create a blank Pivot Table from within the items table on the Collection worksheet to analyze multiple tables. Add the data to the data model. Place the Pivot Table on a new worksheet and name the worksheet Retired Colors Name the Pivot Table Retired Display the names of both tables in the Pivot Table Fields task pane Display the Color Geld as rows and the sum of the Replacement Value field as values Retired colors are often worth more than currently available colors. Therefore, you want to filter the data to show only retired colors Add a filter to display aggregates for retired colors only using the Retired field Note that current colors do not have a retirement date, so you must hiter out the blanks o men Anthelinten Privative Medium 7 Note denne on the w + Such tatt Share U Retired Colors aparentes Percent of Total 5 Chartreuse 640 2335 MON Choco Evergreen 7 Marigold 10.11 Marigold Pearl Gray Perwiele Sea Mist Green Cobalt Type here to search Show transcribed image text Table Tools cel_CHOS_ML2_Fiesta Collection Instructions – Saved References Mailings Review View Help Design Layout Search Points Possible Step Instructions Start Excel. Download and open the file narned Exp19_Excel Cho5_ML2_Fiesta.xlsx. Grader has automatically added your last name to the beginning of the filename. The workbook contains two related tables. You must create a relationship between these tables so that you can create a Pivot Table using data from both tables Create a relationship between the items table using the Color Number field and the Colors table using the Color Number field. Now that the relationship is built, you are ready to create a Pivottable. Create a blank Pivot Table from within the Items table on the Collection worksheet to analyze multiple tables. Add the data to the data model. Place the Pivo Table on a new worksheet and name the worksheet Retired Colors. Name the Pivot Table Retired. Display the names of both tables in the PivotTable Fields task pane. Display the Color field as rows and the sum of the Replacement Value field as values Retired colors are often worth more than currently available colors. Therefore, you want to filter the data to show only retired colors Add a filter to display aggregates for retired colors only using the Retired field. Note that current colors do not have a retirement date, so you must filter out the blanks Apply the Light Green, Pivot Style Medium 7. Note, depending on the version of Office used, the style name may be Pivot Style Medium 7. In the Retired Colors sheet, format the values with Accounting Number Format with two decimal places In cell B3, create a custom heading named Replacement Values. Change Row Labels in cell A3 to Retired Colors 9 You want to add a second value field to display values as percentages of the grant total. Add a second Replacement Value field below the current field in the values area Select the option to display the values as percentages of the grand total Type the custom name Percent of Total 10 Add a slicer for the Color field Select these colors to dislav Anrient Chartreuse llac
References 10 Mailings Review View Help Design Layout Search Add a slicer for the Color field. Select these colors to display Apricot Chartreuse, Lilac Marigold Pearl Grey, and Sapphire. Created On: 05222019 bip19 L el ChOS ML2 – Fiesta Collection 10 Grader – Instruction Excel 2019 Prod Step Points Instructions Possible You want to customize the slicer Apply the Light Green, Slicer Style Light 6 style Note depending on the version of Office used, the style name may be Slicer Style Light 6 Display three columns within the sicer window Change the button width to 1.5 inches. Move the slicer so that the top left corner starts in cell E2 A PivotChart will create a visual illustration of the data in the Pivot Table Create a clustered column PivotChart and place it on a new chart sheet named Retired PivotChart Now that the PivotChart is created, you are ready to format it Change the chart title to Replacement Value of Retired Items Change the data point il color to Purple Change the value as font size to 11 and apply Black Text 1 font color Change the category as font size to 11 and apply Black Text 1 font color. Hide the field buttons on the PivotChart. JO e a wg
Table Tools 19_Excel Cho5_ML2 Fiesta_Collection Instructions. Saved References Mailings Review View Help Design Layout Search Grader-Instructions Excel 2019 Project Step Instructions Points Possible You want to customize the slicer Apply the Light Green Slicer Style Light 6 style Note depending on the version of Office used, the style name may be Slicer Style Light 6. Display three columns within the slicer window. Change the button width to 1.5 inches. Move the slicer so that the top-left corner starts in cell E2 A PivotChart will create a visual illustration of the data in the PivotTable Create a clustered column PivotChart and place it on a new chart sheet named Retired PivotChart Now that the PivotChart is created, you are ready to format it Change the chart title to Replacement Value of Retired Items Change the Lilac data point fill color to Purple Change the value as font size to 11 and apply Black Text 1 font color Change the category axis font size to 11 and apply Black, Text 1 font color. Hide the field buttons on the PivotChart. On all sheets, create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side Ensure the worksheets are in the following order Color List, Retired PivotChart Retired Colors Collection 17 Save and close Exp19_Excel_CHO_ML2_Fiestaxlsx Exit Excel Submit the file as directed DOBê e a wg
File Insert Draw Page Layout Formulas Data Review View Help Time what you want to do Share PC Home Хаа Псору – 20 P etere to watch LOWO
File Home Insert Draw Data Review Page Layout 11 O Formulas AA . A Caliburi BIV View Help Design Wrap Text Center – $ .% EE Entus- Copy from Tell me what you want to do EE . Condtional Format as Cell Formatting table Styles Styles Insert Delete Format inter Chyboard X Color Number Color Numm um 830 er Spiece Place Setting Covered Casserole Pitcher Large Disc eray Set 104 S 104 Replacement Value 6.95 Keith’s Antique Store A la Replac e d Thayetion O by Auction 24 thay Action 21.99 Replacements, the 1999 by Auction 15. Replacements, 7.99 Downtown Antique Store 41.99 Replacements, 19. Replacements, Lid 1.9 The Home Laughlin China Co. 32. The Home Layhin China Co. 2.99 The Home Lwin China Coc 25.99 The Home in China Co. 21.28 bay Auction 19.09 The Home Cina Coc 159 The Home Cina C 15 The Home Cinco Salt and pepper Set Bowl Large 1 Individual Creamer Luncheon Plate Carate Covered Coffee Server Sugar Cream Tray Set Patcher Large Disc 5 Pece Plate Setting 101 AD Cup and Saucer Chop Plate Oy Salt and pepper Set 101 101 Soon Rest 12 The Chica 10 The 101 6 The Home Cina C Piece Pace Setting Collection Color List Type here to search o e o
Project Description: Your Aunt Laura has been collecting Fiesta dinnerware, a popular brand from the Homer Laughlin China Company, since 1986. You help her maintain an inventory So far, you and Aunt Laura have created a table of color numbers, color names year introduced, and year retired, if applicable. In a second table, you entered color numbers, item numbers, items, current value, and source. Previously, you helped her research current replacement costs, however, you believe the retired colors may be worth more now. Laura is especially interested in the values of retired colors so that she can provide this information for her insurance agent. You will build a Pivot Table and add slicers to help her with the analysis Steps to Perform: Step Instructions Points Possible Start Excel Download and open the file named Exp19 Excel Ch05 ML2 Fiesta xlsx Grader has automatically added your last name to the beginning of the filename. The workbook contains two related tables. You must create a relationship between these tables so that you can create a Pivot Table using data from both tables Create a relationship between the items table using the Color Number field and the Colors table using the Color Number field. Now that the relationship is built, you are ready to create a Pivot Table Create a blank Pivot Table from within the items table on the Collection worksheet to analyze multiple tables. Add the data to the data model. Place the Pivot Table on a new worksheet and name the worksheet Retired Colors Name the Pivot Table Retired Display the names of both tables in the Pivot Table Fields task pane Display the Color Geld as rows and the sum of the Replacement Value field as values Retired colors are often worth more than currently available colors. Therefore, you want to filter the data to show only retired colors Add a filter to display aggregates for retired colors only using the Retired field Note that current colors do not have a retirement date, so you must hiter out the blanks o men Anthelinten Privative Medium 7 Note denne on the w
+ Such tatt Share U Retired Colors aparentes Percent of Total 5 Chartreuse 640 2335 MON Choco Evergreen 7 Marigold 10.11 Marigold Pearl Gray Perwiele Sea Mist Green Cobalt Type here to search

Expert Answer

Answer to Table Tools cel_CHOS_ML2_Fiesta Collection Instructions – Saved References Mailings Review View Help Design Layout Searc…

Tables Please Select True Statements Possible Create Great Looking Tables Using R Code Pos Q43863616

Tables: Please select ALL of the true statementsIt is possible to create great looking tables using Rcode.It is possible to create great looking tables usingLaTeX.It is possible to create great looking tables usingMarkdown.

Expert Answer

Answer to Tables: Please select ALL of the true statementsIt is possible to create great looking tables using R code.It is possibl…