{"id":"https://openalex.org/W2374764992","doi":null,"title":"Excel Calculation and Application in Analysis of Variance for Orthogonal Experiment","display_name":"Excel Calculation and Application in Analysis of Variance for Orthogonal Experiment","alternate_titles":[],"publication_year":2011,"publication_date":"2011-01-01","ids":{"openalex":"https://openalex.org/W2374764992","mag":"2374764992"},"language":"en","primary_location":{"id":"mag:2374764992","doi":null,"is_oa":false,"landing_page_url":"https://oversea.cnki.net/kcms/detail/detail.aspx?dbcode=CJFD&filename=ZHOU201110024","pdf_url":null,"source":{"id":"https://openalex.org/S2764999002","display_name":"Chinese Journal of Pharmaceuticals","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4361727498","host_organization_name":"Shanghai Institute of Pharmaceutical Industry","host_organization_lineage":["https://openalex.org/P4361727498"],"host_organization_lineage_names":["Shanghai Institute of Pharmaceutical Industry"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Chinese Journal of Pharmaceuticals","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2374764992"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5014467195","display_name":"Fan Bugao","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Fan Bugao","raw_affiliation_strings":["Shanghai Changzheng Fumin Jinshan Pharmaceutical Co"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Shanghai Changzheng Fumin Jinshan Pharmaceutical Co","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5014467195"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11798","display_name":"Optimal Experimental Design Methods","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11798","display_name":"Optimal Experimental Design Methods","score":0.9970999956130981,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T13141","display_name":"Statistical Methods and Applications","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13487","display_name":"Statistical and numerical algorithms","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/2604","display_name":"Applied Mathematics"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/orthogonal-experimental-design","display_name":"orthogonal experimental design","score":0.8259999752044678},{"id":"https://openalex.org/keywords/analysis-of-variance","display_name":"analysis of variance","score":0.7360000014305115},{"id":"https://openalex.org/keywords/range-analysis","display_name":"range analysis","score":0.8140000104904175},{"id":"https://openalex.org/keywords/excel-spreadsheet-calculation","display_name":"Excel spreadsheet calculation","score":0.5410000085830688},{"id":"https://openalex.org/keywords/pharmaceutical-process-optimization","display_name":"pharmaceutical process optimization","score":0.5059999823570251},{"id":"https://openalex.org/keywords/data-processing-model","display_name":"data processing model","score":0.7289999723434448}],"concepts":[{"id":"https://openalex.org/C196083921","wikidata":"https://www.wikidata.org/wiki/Q7915758","display_name":"Variance (accounting)","level":2,"score":0.5922999978065491},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.5921705961227417},{"id":"https://openalex.org/C42632107","wikidata":"https://www.wikidata.org/wiki/Q2031860","display_name":"Orthogonal array","level":3,"score":0.5724819302558899},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4592589735984802},{"id":"https://openalex.org/C3018901056","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Ms excel","level":2,"score":0.42529240250587463},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.3964480459690094},{"id":"https://openalex.org/C459310","wikidata":"https://www.wikidata.org/wiki/Q117801","display_name":"Computational science","level":1,"score":0.32014238834381104},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.0711413025856018},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.06678462028503418},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.06573799252510071},{"id":"https://openalex.org/C83469408","wikidata":"https://www.wikidata.org/wiki/Q2036525","display_name":"Taguchi methods","level":2,"score":0.0},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.0},{"id":"https://openalex.org/C146978453","wikidata":"https://www.wikidata.org/wiki/Q3798668","display_name":"Aerospace engineering","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2374764992","doi":null,"is_oa":false,"landing_page_url":"https://oversea.cnki.net/kcms/detail/detail.aspx?dbcode=CJFD&filename=ZHOU201110024","pdf_url":null,"source":{"id":"https://openalex.org/S2764999002","display_name":"Chinese Journal of Pharmaceuticals","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4361727498","host_organization_name":"Shanghai Institute of Pharmaceutical Industry","host_organization_lineage":["https://openalex.org/P4361727498"],"host_organization_lineage_names":["Shanghai Institute of Pharmaceutical Industry"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Chinese Journal of Pharmaceuticals","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2386903991","https://openalex.org/W2360271183","https://openalex.org/W1550757497","https://openalex.org/W123791119","https://openalex.org/W1000527201","https://openalex.org/W315383673","https://openalex.org/W7098378806","https://openalex.org/W1136631408","https://openalex.org/W1487666566","https://openalex.org/W6946219903"],"abstract_inverted_index":{"A":[0],"data":[1,43],"processing":[2,44],"model":[3,27],"with":[4],"Excel":[5],"of":[6,21,25,45],"orthogonal":[7,19,47],"design":[8],"for":[9],"range":[10],"analysis":[11,14],"and":[12,30,38],"variance":[13],"was":[15,28],"introduced":[16],"through":[17],"an":[18],"layout":[20],"L_9(3~4).The":[22],"calculation":[23],"procedure":[24],"this":[26],"straightforward,accurate":[29],"fast.The":[31],"functions":[32],"used":[33],"were":[34],"easy":[35],"to":[36],"understand":[37],"could":[39],"be":[40],"applied":[41],"in":[42],"other":[46],"layouts.":[48]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2374764992","counts_by_year":[{"year":2022,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
